/*
 Navicat Premium Data Transfer

 Source Server         : 华为云
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : 114.115.174.32:3306
 Source Schema         : fyt_sugar

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 06/02/2023 15:10:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cars_access_whitelist
-- ----------------------------
DROP TABLE IF EXISTS `cars_access_whitelist`;
CREATE TABLE `cars_access_whitelist` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `Mobile` varchar(255) NOT NULL DEFAULT '0' COMMENT '手机号码',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='访问白名单';

-- ----------------------------
-- Records of cars_access_whitelist
-- ----------------------------
BEGIN;
INSERT INTO `cars_access_whitelist` VALUES (1594595706834915328, '13511084034', b'1', '2022-11-21 15:36:57', '李四', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for cars_activity
-- ----------------------------
DROP TABLE IF EXISTS `cars_activity`;
CREATE TABLE `cars_activity` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Title` varchar(255) NOT NULL DEFAULT '0' COMMENT '活动名称',
  `StarTime` datetime NOT NULL COMMENT '开始时间',
  `EndTime` datetime NOT NULL COMMENT '结束时间',
  `Summary` varchar(900) DEFAULT NULL COMMENT '活动简介',
  `Content` longtext COMMENT '活动内容',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='活动表';

-- ----------------------------
-- Records of cars_activity
-- ----------------------------
BEGIN;
INSERT INTO `cars_activity` VALUES (1575685267996676096, 0, '与”魔方“拍照解锁奖品', '2022-09-01 00:00:00', '2022-10-30 13:48:40', '', '', b'1', '1900-01-01 00:00:00', 'Admin', '2022-09-30 13:49:40', 'Admin');
COMMIT;

-- ----------------------------
-- Table structure for cars_activity_apply
-- ----------------------------
DROP TABLE IF EXISTS `cars_activity_apply`;
CREATE TABLE `cars_activity_apply` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `ActivityId` bigint NOT NULL DEFAULT '0' COMMENT '活动编号',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `Name` varchar(255) DEFAULT NULL COMMENT '姓名',
  `Mobile` varchar(255) NOT NULL COMMENT '手机号码',
  `Will` varchar(255) DEFAULT NULL COMMENT '所属分会',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='活动-报名';

-- ----------------------------
-- Records of cars_activity_apply
-- ----------------------------
BEGIN;
INSERT INTO `cars_activity_apply` VALUES (1575776737411862528, 0, 1575685267996676096, 1511955043186774017, '李先生', '13511924034', '管理分会', '2022-09-30 17:17:05', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for cars_game
-- ----------------------------
DROP TABLE IF EXISTS `cars_game`;
CREATE TABLE `cars_game` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Name` varchar(50) NOT NULL COMMENT '游戏名称',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `Summary` varchar(2000) DEFAULT NULL COMMENT '规则',
  `ConfigRule` varchar(2000) DEFAULT NULL COMMENT '配置相关获得积分策略',
  `AddTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='游戏设置表';

-- ----------------------------
-- Records of cars_game
-- ----------------------------
BEGIN;
INSERT INTO `cars_game` VALUES (1514482213431939072, 0, '拼图游戏', b'1', '<p>点击空白区域相邻图片后移动，移动步数越少所获得积分越高，难度不同获得积分数量不同。</p>\n<p>中途结束游戏，将不获得积分。</p>', '[{\"Level\":1,\"Rule\":[{\"Min\":20,\"Max\":50,\"Point\":500},{\"Min\":50,\"Max\":100,\"Point\":300},{\"Min\":100,\"Max\":300,\"Point\":200},{\"Min\":300,\"Max\":100000,\"Point\":100}]},{\"Level\":2,\"Rule\":[{\"Min\":20,\"Max\":100,\"Point\":1000},{\"Min\":100,\"Max\":300,\"Point\":800},{\"Min\":300,\"Max\":500,\"Point\":500},{\"Min\":500,\"Max\":10000,\"Point\":200}]},{\"Level\":3,\"Rule\":[{\"Min\":20,\"Max\":200,\"Point\":2000},{\"Min\":200,\"Max\":500,\"Point\":1500},{\"Min\":500,\"Max\":800,\"Point\":1000},{\"Min\":800,\"Max\":1000,\"Point\":500},{\"Min\":1000,\"Max\":100000,\"Point\":300}]}]', '2022-04-11 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for cars_prize
-- ----------------------------
DROP TABLE IF EXISTS `cars_prize`;
CREATE TABLE `cars_prize` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Name` varchar(100) NOT NULL COMMENT '活动名称',
  `SubName` varchar(100) DEFAULT NULL COMMENT '副标题',
  `StartTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '开始时间',
  `EndTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '结束时间',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '活动状态',
  `PickCount` int NOT NULL DEFAULT '0' COMMENT '中奖次数',
  `Prizes` varchar(1000) DEFAULT NULL COMMENT '奖品',
  `DrawNumber` varchar(1000) DEFAULT NULL COMMENT '设置的抽奖次数',
  `Summary` longtext COMMENT '活动规则',
  `CreateTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='奖品表';

-- ----------------------------
-- Records of cars_prize
-- ----------------------------
BEGIN;
INSERT INTO `cars_prize` VALUES (1506567310507380736, 0, '幸运大转盘', '全场通用，保养补贴，尽享优惠', '2022-04-10 21:03:43', '2022-04-29 21:03:43', b'1', 17, '[{\"Id\":\"0\",\"Name\":\"一等奖\",\"Ratio\":1,\"Code\":\"1000积分\",\"Users\":[]},{\"Id\":null,\"Name\":\"二等奖\",\"Ratio\":10,\"Code\":\"代金券\",\"Users\":[]},{\"Id\":null,\"Name\":\"三等奖\",\"Ratio\":20,\"Code\":\"玻璃水一瓶\",\"Users\":[]},{\"Id\":null,\"Name\":\"谢谢参与\",\"Ratio\":69,\"Code\":\"谢谢参与\",\"Users\":[]}]', '[{\"Id\":1511955043186774017,\"Number\":20}]', '<p>每位用户注册后可获得一次抽奖机会，每邀请一位朋友注册可额外在获得一次机会，所获得抽奖机会仅限规定时间内使用。</p>', '2022-04-10 21:03:43');
COMMIT;

-- ----------------------------
-- Table structure for cars_prizelog
-- ----------------------------
DROP TABLE IF EXISTS `cars_prizelog`;
CREATE TABLE `cars_prizelog` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `PrizeId` bigint NOT NULL DEFAULT '0' COMMENT '奖品ID',
  `PrizeInfo` varchar(500) DEFAULT NULL COMMENT '中奖信息',
  `Status` bit(1) NOT NULL DEFAULT b'0' COMMENT '发放状态',
  `CreateTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '中奖时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='抽奖记录';

-- ----------------------------
-- Table structure for cars_reserve
-- ----------------------------
DROP TABLE IF EXISTS `cars_reserve`;
CREATE TABLE `cars_reserve` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `Name` varchar(100) DEFAULT NULL COMMENT '姓名',
  `Sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `Mobile` varchar(50) DEFAULT NULL COMMENT '电话',
  `City` varchar(100) DEFAULT NULL COMMENT '城市',
  `County` varchar(100) DEFAULT NULL COMMENT '区县',
  `CarType` varchar(100) DEFAULT NULL COMMENT '车型',
  `ReserveTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '预约时间',
  `Status` bit(1) NOT NULL DEFAULT b'0' COMMENT '处理状态',
  `CreateTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='预约试驾';

-- ----------------------------
-- Records of cars_reserve
-- ----------------------------
BEGIN;
INSERT INTO `cars_reserve` VALUES (1511967662069125120, 0, 1511955043186774017, '李先生', '男', '13654545214', '北京市-市辖区-东城区', NULL, '北京X7 PHEV', '2022-04-29 00:00:00', b'0', '2022-04-07 15:22:36');
COMMIT;

-- ----------------------------
-- Table structure for cm_comment
-- ----------------------------
DROP TABLE IF EXISTS `cm_comment`;
CREATE TABLE `cm_comment` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `CommunityId` bigint NOT NULL DEFAULT '0' COMMENT '社区编号',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `Audit` bit(1) NOT NULL DEFAULT b'0' COMMENT '审核状态',
  `Content` varchar(900) NOT NULL COMMENT '评论内容',
  `Star` int NOT NULL DEFAULT '0' COMMENT '评星',
  `ReplyBody` varchar(4000) DEFAULT NULL COMMENT '回复内容',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社区评论';

-- ----------------------------
-- Records of cm_comment
-- ----------------------------
BEGIN;
INSERT INTO `cm_comment` VALUES (1579768496437465089, 0, 1579015632408678400, 1511955043186774017, b'1', '测试评论内容AAA', 0, '[]', '2022-10-11 17:38:55', 'Admin', NULL, NULL);
INSERT INTO `cm_comment` VALUES (1579768835496611840, 0, 1579015632408678400, 1511955043186774017, b'1', '测试内容bbbbb', 0, '[{\"UserId\":1511955043186774017,\"NickName\":\"Jason.付裕\",\"Avatar\":\"https://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoqicgaib4z5woLNMdib47TxN0RKpuMLEhC0bb27UiacsoQy8jMntic7QXMu01E2gPaLoNm5tadXmDX6Qw/132\",\"Content\":\"测试回复1\",\"ReplyTime\":\"2022-10-11T17:40:24.845366+08:00\",\"ByUserId\":1511955043186774017,\"ByNickName\":\"Jason.付裕\"}]', '2022-10-11 17:40:16', 'Admin', '2022-10-11 17:40:25', 'Admin');
COMMIT;

-- ----------------------------
-- Table structure for cm_community
-- ----------------------------
DROP TABLE IF EXISTS `cm_community`;
CREATE TABLE `cm_community` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `Title` varchar(255) DEFAULT NULL COMMENT '标题',
  `Summary` varchar(900) NOT NULL COMMENT '简介',
  `ImageArr` varchar(900) DEFAULT NULL COMMENT '图片列表',
  `VideoUrl` varchar(255) DEFAULT NULL COMMENT '视频地址',
  `Praise` int NOT NULL DEFAULT '0' COMMENT '点赞数量',
  `Comment` int NOT NULL DEFAULT '0' COMMENT '评论数量',
  `Share` int NOT NULL DEFAULT '0' COMMENT '分享数量',
  `Status` bit(1) NOT NULL DEFAULT b'0' COMMENT '审核状态',
  `IsTop` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否推荐',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社区内容';

-- ----------------------------
-- Records of cm_community
-- ----------------------------
BEGIN;
INSERT INTO `cm_community` VALUES (1579015632408678400, 0, 1511955043186774017, '测试社区标题', '测试社区内容', '[\n  \'https://fuss10.elemecdn.com/a/3f/3302e58f9a181d2509f3dc0fa68b0jpeg.jpeg\',\n  \'https://fuss10.elemecdn.com/1/34/19aa98b1fcb2781c4fba33d850549jpeg.jpeg\',\n  \'https://fuss10.elemecdn.com/0/6f/e35ff375812e6b0020b6b4e8f9583jpeg.jpeg\',\n  \'https://fuss10.elemecdn.com/9/bb/e27858e973f5d7d3904835f46abbdjpeg.jpeg\',\n  \'https://fuss10.elemecdn.com/d/e6/c4d93a3805b3ce3f323f7974e6f78jpeg.jpeg\',\n  \'https://fuss10.elemecdn.com/3/28/bbf893f792f03a54408b3b7a7ebf0jpeg.jpeg\',\n  \'https://fuss10.elemecdn.com/2/11/6535bcfb26e4c79b48ddde44f4b6fjpeg.jpeg\',\n]', '', 1, 3, 0, b'1', b'1', '2022-10-09 15:47:18', 'Admin', NULL, NULL);
INSERT INTO `cm_community` VALUES (1579355240564658176, 0, 1511955043186774017, NULL, '测试发表内容', '[\"http://192.168.0.138:5000/upload/community/20221010/83M1VFPJfyaA7222890f77c810bc2b284af32f1db319.png\"]', NULL, 1, 0, 0, b'1', b'1', '2022-10-10 14:16:47', 'Admin', NULL, NULL);
INSERT INTO `cm_community` VALUES (1579773647353155584, 0, 1511955043186774017, '测试标题', '测试内容测试内容测试内容测试内容测试内容测试内容测试内容测试内容测试内容测试内容测试内容测试内容测试内容测试内容测试内容', '[\"http://192.168.0.138:5000/upload/community/20221011/tmp_bf753616d139243802c0b09fe74d6b62b3f00763043c17e2.jpg\",\"http://192.168.0.138:5000/upload/community/20221011/tmp_fdba4bf7ae667817f47ed3c4cd40465a2d314147356c310d.jpg\"]', NULL, 0, 0, 0, b'1', b'1', '2022-10-11 17:59:23', 'Admin', NULL, NULL);
INSERT INTO `cm_community` VALUES (1579815151299858433, 0, 1511955043186774017, '111111111111', '22222222222222', '[\"http://localhost:5000/upload/community/20221011/R5tYdrxnvT0J7222890f77c810bc2b284af32f1db319.png\",\"http://localhost:5000/upload/community/20221011/ekHGwaYvEIKV3eb2d5f5e0b9453e24b22b83ee1ef4d1.png\"]', NULL, 0, 0, 0, b'1', b'0', '2022-10-11 20:44:18', 'Admin', NULL, NULL);
INSERT INTO `cm_community` VALUES (1579816425340669952, 0, 1511955043186774017, '1212121aaaaaaaaa', '22223111111', '[\"http://localhost:5000/upload/community/20221011/5gMeS7IBacj2879892c411329650200dd47a7921d1cb.mp4\"]', 'http://localhost:5000/upload/community/20221011/5gMeS7IBacj2879892c411329650200dd47a7921d1cb.mp4', 0, 0, 0, b'1', b'0', '2022-10-11 20:49:22', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for cm_medal
-- ----------------------------
DROP TABLE IF EXISTS `cm_medal`;
CREATE TABLE `cm_medal` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Name` varchar(50) NOT NULL DEFAULT '0' COMMENT '勋章名称',
  `Img` varchar(255) DEFAULT NULL COMMENT '勋章图片',
  `Summary` varchar(900) DEFAULT NULL COMMENT '获得条件',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社区-勋章';

-- ----------------------------
-- Records of cm_medal
-- ----------------------------
BEGIN;
INSERT INTO `cm_medal` VALUES (1579010179406630913, 0, '勋章1', 'http://192.168.0.138:5000/upload/community/medal/xunz1.png', '111', '2022-10-09 15:25:38', NULL, '2022-10-09 15:27:36', 'Admin');
INSERT INTO `cm_medal` VALUES (1580393894057742336, 0, '勋章2', 'http://localhost:5000/upload/community/medal/xunz1.png', '勋章2', '2022-10-13 11:04:01', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for cm_medal_user
-- ----------------------------
DROP TABLE IF EXISTS `cm_medal_user`;
CREATE TABLE `cm_medal_user` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `MedalId` bigint NOT NULL DEFAULT '0' COMMENT '勋章编号',
  `IsWear` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否佩戴',
  `IsNeck` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否领取',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社区-勋章用户获得';

-- ----------------------------
-- Records of cm_medal_user
-- ----------------------------
BEGIN;
INSERT INTO `cm_medal_user` VALUES (1580095813856661504, 0, 1511955043186774017, 1579010179406630913, b'0', b'1', '2022-10-12 15:19:33');
INSERT INTO `cm_medal_user` VALUES (1580398807068315648, 0, 1511955043186774017, 1580393894057742336, b'0', b'1', '2022-10-13 11:23:33');
COMMIT;

-- ----------------------------
-- Table structure for cm_praise_share
-- ----------------------------
DROP TABLE IF EXISTS `cm_praise_share`;
CREATE TABLE `cm_praise_share` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Type` int NOT NULL DEFAULT '1' COMMENT '类型1=点赞2=分享',
  `CommunityId` bigint NOT NULL DEFAULT '0' COMMENT '社区编号',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社区点赞';

-- ----------------------------
-- Records of cm_praise_share
-- ----------------------------
BEGIN;
INSERT INTO `cm_praise_share` VALUES (1579397973077528576, 0, 1, 1579355240564658176, 1511955043186774017, '2022-10-10 17:06:35');
INSERT INTO `cm_praise_share` VALUES (1579398083555495936, 0, 1, 1579015632408678400, 1511955043186774017, '2022-10-10 17:07:02');
COMMIT;

-- ----------------------------
-- Table structure for cms_adv_column
-- ----------------------------
DROP TABLE IF EXISTS `cms_adv_column`;
CREATE TABLE `cms_adv_column` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `ParentId` bigint NOT NULL DEFAULT '0' COMMENT '父编号',
  `ParentIdList` varchar(128) NOT NULL COMMENT '父编号集合',
  `Layer` int NOT NULL DEFAULT '1' COMMENT '层级',
  `Name` varchar(32) NOT NULL COMMENT '栏目名称',
  `Flag` varchar(32) DEFAULT NULL COMMENT '栏目类型',
  `Width` int NOT NULL DEFAULT '0' COMMENT '栏目宽度',
  `Height` int NOT NULL DEFAULT '0' COMMENT '栏目高度',
  `Sort` int DEFAULT NULL COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '栏目状态',
  `Summary` varchar(512) DEFAULT NULL COMMENT '栏目说明',
  `SiteId` bigint NOT NULL DEFAULT '0' COMMENT '站点ID',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='广告位栏目表 ';

-- ----------------------------
-- Records of cms_adv_column
-- ----------------------------
BEGIN;
INSERT INTO `cms_adv_column` VALUES (1366296925808234496, 0, '1366296925808234496,', 1, '小程序', 'C', 0, 0, 0, b'1', NULL, 0, '2021-03-01 15:59:06', NULL, '0001-01-01 00:00:00', NULL);
INSERT INTO `cms_adv_column` VALUES (1366318607604256768, 1366296925808234496, '1366296925808234496,1366318607604256768,', 2, '轮播图', 'A', 790, 300, 0, b'1', NULL, 0, '2021-03-01 17:25:16', NULL, '0001-01-01 00:00:00', NULL);
INSERT INTO `cms_adv_column` VALUES (1382891060254085120, 0, '1382891060254085120,', 1, '友情链接', 'F', 0, 0, NULL, b'1', NULL, 0, '2021-04-16 10:58:16', '张三', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for cms_adv_info
-- ----------------------------
DROP TABLE IF EXISTS `cms_adv_info`;
CREATE TABLE `cms_adv_info` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `ColumnId` bigint NOT NULL DEFAULT '0' COMMENT '栏目Id',
  `Title` varchar(128) NOT NULL COMMENT '广告名称',
  `Types` int NOT NULL DEFAULT '1' COMMENT '广告位类型',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `ImgUrl` varchar(128) DEFAULT NULL COMMENT '广告位图片',
  `LinkUrl` varchar(128) DEFAULT NULL COMMENT '连接地址',
  `Target` varchar(32) NOT NULL COMMENT '跳转方式',
  `Summary` varchar(512) DEFAULT NULL COMMENT '描述',
  `Codes` varchar(512) DEFAULT NULL COMMENT '广告位代码',
  `IsTimeLimit` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否开启时间限制',
  `BeginTime` datetime DEFAULT NULL COMMENT '开始时间',
  `EndTime` datetime DEFAULT NULL COMMENT '结束时间',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `Hits` int NOT NULL DEFAULT '0' COMMENT '广告点击率',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='广告位信息表 ';

-- ----------------------------
-- Records of cms_adv_info
-- ----------------------------
BEGIN;
INSERT INTO `cms_adv_info` VALUES (1366322064696414208, 1382891060254085120, '高端网站建设', 1, b'1', NULL, 'http://www.feiyit.com', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2021-03-01 17:39:00', NULL, '2021-05-07 20:48:10', '张三');
INSERT INTO `cms_adv_info` VALUES (1390649751279636480, 1382891060254085120, 'APP开发', 1, b'1', NULL, 'http://www.feiyit.com', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2021-03-01 17:39:00', '张三', '2021-05-07 20:48:42', '张三');
INSERT INTO `cms_adv_info` VALUES (1390650611900485632, 1382891060254085120, '商城开发', 1, b'1', NULL, 'http://www.feiyit.com', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2021-05-07 20:51:58', '张三', NULL, NULL);
INSERT INTO `cms_adv_info` VALUES (1390650673787441152, 1382891060254085120, '小程序开发', 1, b'1', NULL, 'http://www.feiyit.com', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2021-05-07 20:52:12', '张三', NULL, NULL);
INSERT INTO `cms_adv_info` VALUES (1390650724366553088, 1382891060254085120, '公众号开发', 1, b'1', NULL, 'http://www.feiyit.com', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2021-05-07 20:52:24', '张三', '2021-05-07 20:52:27', '张三');
INSERT INTO `cms_adv_info` VALUES (1390650796961566720, 1382891060254085120, '小程序开发', 1, b'1', NULL, 'http://www.feiyit.com', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2021-05-07 20:52:24', '张三', NULL, NULL);
INSERT INTO `cms_adv_info` VALUES (1483256044233822208, 1366318607604256768, '图1', 1, b'1', '/upload/images/20220118/1.jpg', '1', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2022-01-18 09:52:53', NULL, '0001-01-01 00:00:00', NULL);
INSERT INTO `cms_adv_info` VALUES (1483320193190072322, 1366318607604256768, '图2', 1, b'1', '/upload/images/20220118/2.jpg', '11', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2022-01-18 14:07:47', NULL, '0001-01-01 00:00:00', NULL);
INSERT INTO `cms_adv_info` VALUES (1483320313721786368, 1366318607604256768, '图3', 1, b'1', '/upload/images/20220118/5.jpg', '1', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2022-01-18 14:08:16', NULL, '0001-01-01 00:00:00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for cms_article
-- ----------------------------
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `ColumnId` bigint NOT NULL DEFAULT '0' COMMENT '栏目Id',
  `Title` varchar(128) NOT NULL COMMENT '文章标题',
  `TitleColor` varchar(64) DEFAULT NULL COMMENT '标题颜色',
  `SubTitle` varchar(128) DEFAULT NULL COMMENT '副标题',
  `Author` varchar(32) DEFAULT NULL COMMENT '作者',
  `Source` varchar(32) DEFAULT NULL COMMENT '来源',
  `Sort` int NOT NULL DEFAULT '0' COMMENT '权重',
  `LinkUrl` varchar(128) DEFAULT NULL COMMENT '外部链接地址',
  `Tag` varchar(64) DEFAULT NULL COMMENT '标签',
  `ImgUrl` varchar(512) DEFAULT NULL COMMENT '宣传图 支持多图',
  `VideoUrl` varchar(512) DEFAULT NULL COMMENT '视频地址',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '发布状态',
  `KeyWord` varchar(128) DEFAULT NULL COMMENT 'Seo关键字',
  `Summary` varchar(512) DEFAULT NULL COMMENT 'Seo描述',
  `Content` text COMMENT '文章内容',
  `Attr` varchar(20) NOT NULL COMMENT '是否置顶',
  `Hits` int NOT NULL DEFAULT '0' COMMENT '点击量',
  `DayHits` int NOT NULL DEFAULT '0' COMMENT '当日点击量',
  `WeedHits` int NOT NULL DEFAULT '0' COMMENT '星期点击量',
  `MonthHits` int NOT NULL DEFAULT '0' COMMENT '月点击量',
  `LastHitDate` datetime DEFAULT NULL COMMENT '最后点击时间',
  `DeleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  `CreateTime` datetime NOT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime NOT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='文章表 ';

-- ----------------------------
-- Table structure for cms_column
-- ----------------------------
DROP TABLE IF EXISTS `cms_column`;
CREATE TABLE `cms_column` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `ParentId` bigint NOT NULL DEFAULT '0' COMMENT '父编号',
  `ParentIdList` varchar(500) NOT NULL COMMENT '父编号集合',
  `Number` varchar(32) DEFAULT NULL COMMENT '栏目编号',
  `Title` varchar(32) NOT NULL COMMENT '栏目标题',
  `EnTitle` varchar(64) DEFAULT NULL COMMENT '栏目英文标题',
  `SubTitle` varchar(64) DEFAULT NULL COMMENT '栏目副标题',
  `Layer` int NOT NULL DEFAULT '1' COMMENT '层级',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `SiteId` bigint NOT NULL DEFAULT '0' COMMENT '站点ID',
  `TemplateId` bigint NOT NULL DEFAULT '0' COMMENT '模板ID',
  `TemplateName` varchar(32) DEFAULT NULL COMMENT '模板名称',
  `ImgUrl` varchar(128) DEFAULT NULL COMMENT '栏目图片',
  `LinkUrl` varchar(128) DEFAULT NULL COMMENT '栏目外链',
  `KeyWord` varchar(128) DEFAULT NULL COMMENT '栏目关键字',
  `Summary` varchar(128) DEFAULT NULL COMMENT '栏目描述',
  `Content` text COMMENT '栏目内容',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='栏目表 ';

-- ----------------------------
-- Records of cms_column
-- ----------------------------
BEGIN;
INSERT INTO `cms_column` VALUES (1506535160127033344, 0, 0, '[\"1506535160127033344\"]', NULL, '政策讲解', NULL, NULL, 1, 15, b'1', 0, 1390623120041316352, '文章管理', NULL, NULL, NULL, NULL, '', '2022-03-23 15:35:47', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for cms_message
-- ----------------------------
DROP TABLE IF EXISTS `cms_message`;
CREATE TABLE `cms_message` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `ColumnId` bigint NOT NULL DEFAULT '0' COMMENT '栏目Id',
  `Types` int NOT NULL DEFAULT '1' COMMENT '类型',
  `Title` varchar(64) DEFAULT NULL COMMENT '留言标题',
  `Email` varchar(64) DEFAULT NULL COMMENT '邮箱信息',
  `Mobile` varchar(32) DEFAULT NULL COMMENT '手机号码',
  `Tags` varchar(128) DEFAULT NULL COMMENT '留言标签',
  `Summary` varchar(1024) DEFAULT NULL COMMENT '留言内容',
  `IsRead` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否已读',
  `IsDelete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `UserName` varchar(32) DEFAULT NULL COMMENT '用户姓名',
  `CreateTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='留言消息表';

-- ----------------------------
-- Records of cms_message
-- ----------------------------
BEGIN;
INSERT INTO `cms_message` VALUES (1388447984265596928, 0, 0, 1, '这里面是标题', '7155@qq.com', '135110110110', '测试、游戏、工作、需求', '具体的留言信息，请查看', b'1', b'0', 0, '张三', '2021-05-01 21:45:57', 'string', '2021-05-01 10:58:34', 'string');
INSERT INTO `cms_message` VALUES (1391649539160674304, 0, 0, 0, '留言信息10010220011', 'string', 'string', 'string', 'string', b'0', b'0', 0, 'string', '2021-05-10 07:00:51', 'string', '2021-05-10 07:00:51', 'string');
INSERT INTO `cms_message` VALUES (1391649554780262400, 0, 0, 0, '留言信息10010220011', 'string', 'string', 'string', 'string', b'1', b'1', 0, 'string', '2021-05-10 15:29:21', 'string', '2021-05-10 07:00:51', 'string');
INSERT INTO `cms_message` VALUES (1391649555568791552, 0, 0, 0, '留言信息10010220011', 'string', 'string', 'string', 'string', b'0', b'0', 0, 'string', '2021-05-10 07:00:51', 'string', '2021-05-10 07:00:51', 'string');
INSERT INTO `cms_message` VALUES (1391649557682720768, 0, 0, 0, '留言信息10010220011', 'string', 'string', 'string', 'string', b'1', b'0', 0, 'string', '2021-05-10 15:01:58', 'string', '2021-05-10 07:00:51', 'string');
INSERT INTO `cms_message` VALUES (1391649558261534720, 0, 0, 0, '留言信息10010220011', 'string', 'string', 'string', 'string', b'0', b'0', 0, 'string', '2021-05-10 07:00:51', 'string', '2021-05-10 07:00:51', 'string');
COMMIT;

-- ----------------------------
-- Table structure for cms_site
-- ----------------------------
DROP TABLE IF EXISTS `cms_site`;
CREATE TABLE `cms_site` (
  `Id` bigint NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Name` varchar(32) NOT NULL COMMENT '网站名称',
  `Logo` varchar(128) DEFAULT NULL COMMENT '网站Logo',
  `SiteUrl` varchar(128) DEFAULT NULL COMMENT '网站网址',
  `SeoTitle` varchar(128) DEFAULT NULL COMMENT 'SEO标题',
  `SeoKey` varchar(512) DEFAULT NULL COMMENT 'SEO关键字',
  `SeoDescribe` varchar(512) DEFAULT NULL COMMENT 'SEO描述',
  `Copyright` varchar(1024) DEFAULT NULL COMMENT '网站版权信息',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '网站开启状态',
  `CloseInfo` varchar(1024) DEFAULT NULL COMMENT '网站关闭原因',
  `CompanyTel` varchar(32) DEFAULT NULL COMMENT '公司电话',
  `CompanyFax` varchar(32) DEFAULT NULL COMMENT '公司传真',
  `CompanyEmail` varchar(32) DEFAULT NULL COMMENT '公司邮箱',
  `CompanyAddress` varchar(64) DEFAULT NULL COMMENT '公司地址',
  `CustomerService` varchar(128) DEFAULT NULL COMMENT '客服信息',
  `Codes` varchar(1024) DEFAULT NULL COMMENT '二维码Json(Key:Value)',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='站点表 ';

-- ----------------------------
-- Records of cms_site
-- ----------------------------
BEGIN;
INSERT INTO `cms_site` VALUES (1364837482360868864, 0, 'FytSoa演示站点', '/upload/site/logo.png', 'https://gitee.com/feiyit/fytsoa', 'fytsoa', 'fytsoa', 'fytsoa', '2020 FytSoa. All Rights Reserved.', b'1', '', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-25 15:19:48', NULL, '2022-07-28 14:41:49', 'Admin');
COMMIT;

-- ----------------------------
-- Table structure for cms_template
-- ----------------------------
DROP TABLE IF EXISTS `cms_template`;
CREATE TABLE `cms_template` (
  `Id` bigint NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Name` varchar(32) NOT NULL COMMENT '模板名称',
  `Urls` varchar(128) DEFAULT NULL COMMENT '模板地址',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='模板表 ';

-- ----------------------------
-- Records of cms_template
-- ----------------------------
BEGIN;
INSERT INTO `cms_template` VALUES (1365210485116506112, 0, '单页模板', 'cms/column', b'1', '2021-02-26 16:01:59', NULL, NULL, NULL);
INSERT INTO `cms_template` VALUES (1390623120041316352, 0, '文章管理', 'cms/article', b'1', '2021-05-07 19:02:43', '张三', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for crm_contact
-- ----------------------------
DROP TABLE IF EXISTS `crm_contact`;
CREATE TABLE `crm_contact` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  `CustomerId` bigint NOT NULL DEFAULT '0' COMMENT '所属客户',
  `IsUrgent` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否紧急联系人',
  `Name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `Mobile` varchar(15) DEFAULT NULL COMMENT '手机号码',
  `Tel` varchar(50) DEFAULT NULL COMMENT '座机号',
  `Email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `Sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `Post` varchar(50) DEFAULT NULL COMMENT '职务',
  `County` varchar(255) DEFAULT NULL COMMENT '所属区县',
  `Address` varchar(255) DEFAULT NULL COMMENT '详细地址',
  `Remark` varchar(900) DEFAULT NULL COMMENT '备注',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态1=正常0=关闭',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='联系人';

-- ----------------------------
-- Records of crm_contact
-- ----------------------------
BEGIN;
INSERT INTO `crm_contact` VALUES (1590159548554022913, 0, 1589878696234323968, b'0', '张三', '1355565657', '010-', '', '男', '经理', '海淀区', '', '', b'1', '2022-11-09 09:52:27', NULL, '2022-11-09 09:52:27', '李四');
COMMIT;

-- ----------------------------
-- Table structure for crm_customer
-- ----------------------------
DROP TABLE IF EXISTS `crm_customer`;
CREATE TABLE `crm_customer` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  `Name` varchar(255) NOT NULL DEFAULT '0' COMMENT '客户名称',
  `Number` varchar(50) DEFAULT NULL COMMENT '客户编号',
  `Tel` varchar(255) NOT NULL COMMENT '客户电话',
  `Email` varchar(255) DEFAULT NULL COMMENT '客户邮箱',
  `Source` bigint NOT NULL DEFAULT '0' COMMENT '客户来源',
  `Head` bigint NOT NULL DEFAULT '0' COMMENT '负责人',
  `Level` bigint NOT NULL DEFAULT '0' COMMENT '客户级别',
  `Industry` bigint NOT NULL DEFAULT '0' COMMENT '客户行业',
  `County` varchar(255) DEFAULT NULL COMMENT '所属区县',
  `Address` varchar(255) DEFAULT NULL COMMENT '详细地址',
  `Remark` varchar(900) DEFAULT NULL COMMENT '备注',
  `IsDelete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='客户信息';

-- ----------------------------
-- Records of crm_customer
-- ----------------------------
BEGIN;
INSERT INTO `crm_customer` VALUES (1589878696234323968, 0, '测试客户名称', NULL, '010-22222121', 'admin@nocobase.com', 1589815256375496705, 1260380358965334016, 1589814891039035393, 1589814777079795713, '朝阳区', '四惠', '', b'0', '2022-11-10 14:41:10', NULL, '2022-11-10 14:41:10', '李四');
COMMIT;

-- ----------------------------
-- Table structure for exam_comment
-- ----------------------------
DROP TABLE IF EXISTS `exam_comment`;
CREATE TABLE `exam_comment` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `CategoryId` bigint NOT NULL DEFAULT '0' COMMENT '分类编号',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `Audit` bit(1) NOT NULL DEFAULT b'0' COMMENT '审核状态',
  `Content` varchar(900) NOT NULL COMMENT '评论内容',
  `Star` int NOT NULL DEFAULT '0' COMMENT '评星',
  `ReplyBody` varchar(3000) DEFAULT NULL COMMENT '回复内容',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='评论';

-- ----------------------------
-- Records of exam_comment
-- ----------------------------
BEGIN;
INSERT INTO `exam_comment` VALUES (1551548446584999937, 0, 1547837212773715968, 1511955043186774017, b'1', '测试内容~~~', 0, '[{\"UserId\":1511955043186774017,\"NickName\":\"张三\",\"Avatar\":null,\"Content\":\"不错哦，继续努力\",\"ReplyTime\":\"2022-07-15T17:53:38\",\"ByUserId\":1506196124946534400,\"ByNickName\":\"李四\"},{\"UserId\":1511955043186774017,\"NickName\":\"李四\",\"Avatar\":null,\"Content\":\"你也不错哦，继续努力\",\"ReplyTime\":\"2022-07-15T17:53:38\",\"ByUserId\":1506196124946534400,\"ByNickName\":\"张三\"},{\"UserId\":1511955043186774017,\"NickName\":\"Jason.付裕\",\"Avatar\":\"https://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoqicgaib4z5woLNMdib47TxN0RKpuMLEhC0bb27UiacsoQy8jMntic7QXMu01E2gPaLoNm5tadXmDX6Qw/132\",\"Content\":\"1111111\",\"ReplyTime\":\"2022-07-28T10:34:01.610387+08:00\",\"ByUserId\":1506196124946534400,\"ByNickName\":\"11111\"}]', '2022-07-25 20:42:31', 'Admin', '2022-07-28 10:34:02', 'Admin');
INSERT INTO `exam_comment` VALUES (1551552403839520769, 0, 1547837212773715968, 1511955043186774017, b'1', '少时诵诗书所所', 0, '[{\"UserId\":1511955043186774017,\"NickName\":\"Jason.付裕\",\"Avatar\":\"https://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoqicgaib4z5woLNMdib47TxN0RKpuMLEhC0bb27UiacsoQy8jMntic7QXMu01E2gPaLoNm5tadXmDX6Qw/132\",\"Content\":\"回复内容-少时诵诗书所所\",\"ReplyTime\":\"2022-07-28T10:20:44.478109+08:00\",\"ByUserId\":1511955043186774017,\"ByNickName\":\"Jason.付裕\"},{\"UserId\":1511955043186774017,\"NickName\":\"Jason.付裕\",\"Avatar\":\"https://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoqicgaib4z5woLNMdib47TxN0RKpuMLEhC0bb27UiacsoQy8jMntic7QXMu01E2gPaLoNm5tadXmDX6Qw/132\",\"Content\":\"回复-测试\",\"ReplyTime\":\"2022-07-28T10:21:21.418311+08:00\",\"ByUserId\":1511955043186774017,\"ByNickName\":\"Jason.付裕\"}]', '2022-07-25 20:58:14', 'Admin', '2022-07-28 10:21:21', 'Admin');
INSERT INTO `exam_comment` VALUES (1552491285015826432, 0, 1548951966498033664, 1511955043186774017, b'1', '测试下评论', 0, '[]', '2022-07-28 11:09:01', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for exam_course
-- ----------------------------
DROP TABLE IF EXISTS `exam_course`;
CREATE TABLE `exam_course` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Type` int NOT NULL DEFAULT '1' COMMENT '课程类型(直播、点播、图文)',
  `TeacherId` bigint NOT NULL DEFAULT '0' COMMENT '讲师编号',
  `GradeId` varchar(255) NOT NULL DEFAULT '0' COMMENT '年级编号(多选)',
  `SubjectId` varchar(255) NOT NULL DEFAULT '0' COMMENT '学科编号(多选)',
  `DifficultyId` bigint NOT NULL DEFAULT '0' COMMENT '难度编号',
  `Title` varchar(255) NOT NULL COMMENT '标题',
  `Urls` varchar(900) DEFAULT NULL COMMENT '直播地址',
  `Courses` varchar(900) DEFAULT NULL COMMENT '课程列表Json(名称+视频+打点)',
  `Cover` varchar(255) NOT NULL COMMENT '封面',
  `Audit` bit(1) NOT NULL DEFAULT b'0' COMMENT '审核状态',
  `Status` int NOT NULL DEFAULT '1' COMMENT '上架状态(立即、定时、暂不)',
  `Timing` datetime DEFAULT NULL COMMENT '定时时间',
  `Hits` int NOT NULL DEFAULT '0' COMMENT '点击量',
  `Support` varchar(50) DEFAULT NULL COMMENT '赞|踩',
  `Attr` varchar(255) NOT NULL COMMENT '属性数组(评论、互动、推荐、弹幕、下载、投票)',
  `Dot` varchar(900) DEFAULT NULL COMMENT '打点Json(位置+提示语)',
  `Courseware` varchar(900) DEFAULT NULL COMMENT '课件(名称、排序、文件)',
  `IsDelete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `Summary` varchar(900) DEFAULT NULL COMMENT '视频描述',
  `Content` longtext COMMENT '视频内容',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='课程';

-- ----------------------------
-- Records of exam_course
-- ----------------------------
BEGIN;
INSERT INTO `exam_course` VALUES (1547837212773715968, 0, 1, 1547577478409752577, '[\"1540272019071963137\"]', '[\"1540271878395006976\"]', 1547152666575114241, 'Web前端开发之VUE.JS全家桶实战教程', 'http://localhost:5000/upload/knowledge/mp4/2-1222111.mp4', '[]', 'http://localhost:5000/upload/knowledge/jpg/22.jpeg', b'1', 1, NULL, 371, '{\"Praise\":5,\"Tread\":1}', '[1,3]', '', '[]', b'0', '在有HTML CSS JavaScript的基础上，快速上手。简单小巧的核心，渐进式技术栈，足以应付任何规模的应用。', '<p>易用</p>\n<p>在有HTML CSS JavaScript的基础上，快速上手。</p>\n<p>灵活</p>\n<p>简单小巧的核心，渐进式技术栈，足以应付任何规模的应用。</p>\n<p>性能</p>\n<p>20kb min+gzip 运行大小、超快虚拟 DOM 、最省心的优化。</p>', '2022-07-15 14:55:24', 'Admin', '2022-08-01 09:23:38', 'Admin');
INSERT INTO `exam_course` VALUES (1547838264566747136, 0, 3, 1547577478409752577, '[\"1540272044145512449\"]', '[\"1540271878395006976\"]', 1547152618760048640, 'IT行业职业发展之路', '', '[]', 'http://localhost:5000/upload/knowledge/png/1.png', b'1', 3, NULL, 64, '{\"Praise\":0,\"Tread\":0}', '[1,3]', '', '[{\"Name\":\"学习课件\",\"Url\":\"http://localhost:5000/upload/knowledge/pdf/document.pdf\"}]', b'0', '信息技术（IT即Information Technology）就是感测技术、通信技术、计算机技术和控制技术。也许您不满意这个定义，但这的确是一个又简洁、又具体、又系统、又实用的定义。', '<p>信息技术（IT即Information Technology）就是感测技术、通信技术、计算机技术和控制技术。也许您不满意这个定义，但这的确是一个又简洁、又具体、又系统、又实用的定义。</p>\n<p>感测技术就是获取信息的技术，通信技术就是传递信息的技术，计算机技术就是处理信息的技术，而控制技术就是利用信息的技术。因此这个定义不但给出了信息技术的内容，也明确了信息技术的获取-传递-处理-利用的体系，还摆清了感测、通信、计算机、控制这些概念。比较明确、领域比较清晰、大众比较有感性认识的技术在信息系统中的作用和相互关系。</p>\n<p>感测、通信、计算机和控制这4大技术在信息系统中虽然各司其职，但是从技术要素层次上看，它们又是相互包含、相互交叉、相互融合的。感测、通信、计算机都离不开控制；感测、计算机、控制也都离不开通信；感测、通信、控制更是离不开计算机。</p>\n<p>对人类社会活动一切有用的数据、资料都可以称为信息。</p>\n<p>广义的信息不仅包括企业生产经营活动的信息，还包括国民经济乃至世界经济活动的信息；不仅包括经济信息，还包括科技信息、社会文化信息、生活信息等。</p>\n<p>狭义的信息主要指与企业生产经营活动有关的微观和宏观经济信息。信息手段和信息技术主要是指从事信息处理的电脑系统和从事信息传递的舆论、通讯工具以及相应信息科学理论。因此，信息技术产业是指从事信息的生产、流通和销售信息以及相应信息科学理论。</p>', '2022-07-15 14:59:34', 'Admin', '2022-07-15 15:04:14', 'Admin');
INSERT INTO `exam_course` VALUES (1548951966498033664, 0, 2, 1547577478409752577, '[\"1540272044145512449\"]', '[\"1540271924658180097\"]', 1547152618760048640, '爱与榜样，赋能教育——高校教师信息化教学能力提升系列教学发展', 'http://local.live.jxtvcn.com.cn/live-jxtv/tv_jxtv1.m3u8', '[]', 'http://localhost:5000/upload/knowledge/jpg/live_1.png', b'1', 1, NULL, 39, '{\"Praise\":0,\"Tread\":0}', '[1,3]', '', '[]', b'0', '智慧树高等教育研究院专家 | 智慧树高等教育研究院', '<p>智慧树高等教育研究院专家&nbsp;|&nbsp;智慧树高等教育研究院</p>', '2022-07-18 16:45:02', 'Admin', NULL, NULL);
INSERT INTO `exam_course` VALUES (1548955037584199680, 0, 2, 1547577478409752577, '[\"1540272093231452160\"]', '[\"1540271954144137217\"]', 1547152686498058240, '全国高等院校教育教学新技术赋能教学改革线上直播创新论坛', 'http://local.live.jxtvcn.com.cn/live-jxtv/tv_jxtv1.m3u8', '[]', 'http://localhost:5000/upload/knowledge/jpg/live_2.png', b'1', 1, NULL, 5, '{\"Praise\":0,\"Tread\":0}', '[1,3]', '', '[]', b'0', '南方科技大学', '<p>南方科技大学</p>', '2022-07-18 16:57:14', 'Admin', NULL, NULL);
INSERT INTO `exam_course` VALUES (1548955873634816000, 0, 2, 1548955262205956097, '[\"1540272093231452160\"]', '[\"1540271924658180097\"]', 1547152686498058240, '【四级听力】视听一致法则+同义替换备考技巧', 'http://local.live.jxtvcn.com.cn/live-jxtv/tv_jxtv1.m3u8', '[]', 'http://localhost:5000/upload/knowledge/jpg/live_3.png', b'1', 1, NULL, 1, '{\"Praise\":0,\"Tread\":0}', '[1,3]', '', '[]', b'0', '【四级听力】视听一致法则+同义替换备考技巧', '', '2022-07-18 17:00:33', 'Admin', NULL, NULL);
INSERT INTO `exam_course` VALUES (1548956510871228419, 0, 2, 1548955262205956097, '[\"1540272044145512449\"]', '[\"1540271878395006976\"]', 1547152666575114241, '创造性思维与创新方法', 'http://local.live.jxtvcn.com.cn/live-jxtv/tv_jxtv1.m3u8', '[]', 'http://localhost:5000/upload/knowledge/jpg/live_4.png', b'1', 1, NULL, 1, '{\"Praise\":0,\"Tread\":0}', '[1,3]', '', '[]', b'0', '创新——方法——创造——思维——实践，《创造性思维与创新方法》给你带来更多的锻炼、全新的思维方式、更多创新的可能！', '<p>创新&mdash;&mdash;方法&mdash;&mdash;创造&mdash;&mdash;思维&mdash;&mdash;实践，《创造性思维与创新方法》给你带来更多的锻炼、全新的思维方式、更多创新的可能！</p>', '2022-07-18 17:03:05', 'Admin', NULL, NULL);
INSERT INTO `exam_course` VALUES (1548957317406527488, 0, 1, 1547577478409752577, '[\"1540272044145512449\"]', '[\"1540271954144137217\"]', 1547152618760048640, '创践——大学生创新创业实务', 'http://localhost:5000/upload/knowledge/mp4/2-1222111.mp4', '[]', 'http://localhost:5000/upload/knowledge/png/video_1.png', b'1', 1, NULL, 41, '{\"Praise\":2,\"Tread\":1}', '[1,3]', '', '[]', b'0', '《创践——大学生创新创业实务》是由中国海洋大学牵头，南开大学、四川大学、厦门大学共同制作，海尔集团、泰有投资参与建设的创新创业普适性课程', '<p>《创践&mdash;&mdash;大学生创新创业实务》是由中国海洋大学牵头，南开大学、四川大学、厦门大学共同制作，海尔集团、泰有投资参与建设的创新创业普适性课程，秉承&ldquo;创践精业 立人笃行&rdquo;的育人理念，引导学生通过创新性实践提升创业精神，开创事业和人生新境界，获评首批国家精品在线开放课程、国家一流课程，在创新创业类慕课中选课高校量和学生数均排名全国第一，入选人社部首届全国创业就业展示交流周&ldquo;十大创业培训项目&rdquo;，是高校唯一入选且被列为全国重点推广项目，双创教育经验被纳入《创业中国》案例集，获评山东省教学成果一等奖。</p>', '2022-07-18 17:06:17', 'Admin', '2022-07-28 10:52:09', 'Admin');
COMMIT;

-- ----------------------------
-- Table structure for exam_knowledge
-- ----------------------------
DROP TABLE IF EXISTS `exam_knowledge`;
CREATE TABLE `exam_knowledge` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `GradeId` bigint NOT NULL DEFAULT '0' COMMENT '年级编号',
  `CategoryId` bigint NOT NULL DEFAULT '0' COMMENT '知识库分类编号',
  `Title` varchar(255) NOT NULL COMMENT '标题',
  `Cover` varchar(255) DEFAULT NULL COMMENT '封面',
  `Document` varchar(900) DEFAULT NULL COMMENT '文档',
  `PageCount` int DEFAULT '0' COMMENT '页数',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='知识库';

-- ----------------------------
-- Records of exam_knowledge
-- ----------------------------
BEGIN;
INSERT INTO `exam_knowledge` VALUES (1546315818097315840, 0, 1540271986272505857, 1546303717521887232, '2016 年国考申论真题省级以上（含副省级）综合管理类', 'http://localhost:5000/upload/knowledge/1.png', 'http://localhost:5000/upload/knowledge/document.pdf', 8, '2022-07-11 10:09:55', 'Admin', '2022-07-13 10:48:55', 'Admin');
INSERT INTO `exam_knowledge` VALUES (1550017502002679808, 0, 1540272044145512449, 1546304058426527744, '云计算有什么优势与特点？', 'http://localhost:5000/upload/knowledge/pdf-cover.jpg', 'http://localhost:5000/upload/knowledge/document.pdf', 8, '2022-07-21 15:19:05', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for exam_knowledge_category
-- ----------------------------
DROP TABLE IF EXISTS `exam_knowledge_category`;
CREATE TABLE `exam_knowledge_category` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `GradeId` bigint NOT NULL DEFAULT '0' COMMENT '年级编号',
  `Name` varchar(255) NOT NULL COMMENT '分类名称',
  `ParentId` bigint NOT NULL DEFAULT '0' COMMENT '分类父级',
  `Sort` int DEFAULT '1' COMMENT '排序',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='知识库分类';

-- ----------------------------
-- Records of exam_knowledge_category
-- ----------------------------
BEGIN;
INSERT INTO `exam_knowledge_category` VALUES (1546303691643031552, 0, 1540271986272505857, '插画', 0, 2, '2022-07-11 09:21:44', 'Admin', NULL, NULL);
INSERT INTO `exam_knowledge_category` VALUES (1546303717521887232, 0, 1540271986272505857, '油画', 0, 3, '2022-07-11 09:21:50', 'Admin', NULL, NULL);
INSERT INTO `exam_knowledge_category` VALUES (1546303770776965121, 0, 1540271986272505857, '素描', 0, 4, '2022-07-11 09:22:03', 'Admin', NULL, NULL);
INSERT INTO `exam_knowledge_category` VALUES (1546303797456932865, 0, 1540271986272505857, '机器学习', 0, 5, '2022-07-11 09:22:09', 'Admin', '2022-07-11 09:22:43', 'Admin');
INSERT INTO `exam_knowledge_category` VALUES (1546304025111171074, 0, 1540272019071963137, '音乐', 0, 6, '2022-07-11 09:23:03', 'Admin', NULL, NULL);
INSERT INTO `exam_knowledge_category` VALUES (1546304058426527744, 0, 1540272044145512449, '云计算', 0, 7, '2022-07-11 09:23:11', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for exam_material
-- ----------------------------
DROP TABLE IF EXISTS `exam_material`;
CREATE TABLE `exam_material` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `CategoryId` bigint NOT NULL DEFAULT '0' COMMENT '分类编号',
  `Name` varchar(255) DEFAULT NULL COMMENT '名称',
  `SourceName` varchar(255) NOT NULL COMMENT '原名称',
  `Ext` varchar(90) NOT NULL COMMENT '扩展名',
  `Size` int NOT NULL COMMENT '文件大小',
  `Urls` varchar(255) NOT NULL COMMENT '地址',
  `Cover` varchar(255) DEFAULT NULL COMMENT '视频(封面)',
  `Type` varchar(90) DEFAULT NULL COMMENT '文件模式(上传Upload/转换Convert/剪辑Clip/合并/Merge)',
  `Audit` bit(1) NOT NULL DEFAULT b'0' COMMENT '审核',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='素材';

-- ----------------------------
-- Records of exam_material
-- ----------------------------
BEGIN;
INSERT INTO `exam_material` VALUES (1547047246657359872, 0, 1546689729502777344, '22.jpeg', '22.jpeg', 'jpeg', 37869, '/upload/knowledge/jpg/22.jpeg', NULL, 'Upload', b'1', '2022-07-13 10:36:21', 'Admin', NULL, NULL);
INSERT INTO `exam_material` VALUES (1547047383337144320, 0, 1546694142527148032, '2.png', '2.png', 'png', 406210, '/upload/knowledge/png/2.png', NULL, 'Upload', b'1', '2022-07-13 10:36:54', 'Admin', NULL, NULL);
INSERT INTO `exam_material` VALUES (1547047383374893056, 0, 1546694142527148032, '1.png', '1.png', 'png', 459976, '/upload/knowledge/png/1.png', NULL, 'Upload', b'1', '2022-07-13 10:36:54', 'Admin', NULL, NULL);
INSERT INTO `exam_material` VALUES (1547047506880368641, 0, 1546694255475560448, '2-1222111.mp4', '2.mp4', 'mp4', 60502881, '/upload/knowledge/mp4/2-1222111.mp4', NULL, 'Upload', b'1', '2022-07-13 10:37:23', 'Admin', '2022-07-13 10:40:47', 'Admin');
INSERT INTO `exam_material` VALUES (1547838458846908416, 0, 1546695155996823552, 'document.pdf', 'document.pdf', 'pdf', 391132, '/upload/knowledge/pdf/document.pdf', NULL, 'Upload', b'1', '2022-07-15 15:00:21', 'Admin', NULL, NULL);
INSERT INTO `exam_material` VALUES (1548951384395747332, 0, 1546689729502777344, 'live_3.png', '3.png', 'png', 19126, '/upload/knowledge/jpg/live_3.png', NULL, 'Upload', b'1', '2022-07-18 16:42:43', 'Admin', '2022-07-18 16:43:10', 'Admin');
INSERT INTO `exam_material` VALUES (1548951384395747333, 0, 1546689729502777344, 'live_1.png', '1.png', 'png', 8891, '/upload/knowledge/jpg/live_1.png', NULL, 'Upload', b'1', '2022-07-18 16:42:43', 'Admin', '2022-07-18 16:42:55', 'Admin');
INSERT INTO `exam_material` VALUES (1548951384395747334, 0, 1546689729502777344, 'live_4.png', '4.png', 'png', 8149, '/upload/knowledge/jpg/live_4.png', NULL, 'Upload', b'1', '2022-07-18 16:42:43', 'Admin', '2022-07-18 16:43:16', 'Admin');
INSERT INTO `exam_material` VALUES (1548951384395747335, 0, 1546689729502777344, 'live_2.png', '2.png', 'png', 9711, '/upload/knowledge/jpg/live_2.png', NULL, 'Upload', b'1', '2022-07-18 16:42:43', 'Admin', '2022-07-18 16:43:02', 'Admin');
INSERT INTO `exam_material` VALUES (1548956995510472705, 0, 1546694142527148032, 'video_1.png', '788ac78f755a428197be3e6987a56811992280757621468723.png', 'png', 51049, '/upload/knowledge/png/video_1.png', NULL, 'Upload', b'1', '2022-07-18 17:05:01', 'Admin', '2022-07-18 17:05:16', 'Admin');
COMMIT;

-- ----------------------------
-- Table structure for exam_material_category
-- ----------------------------
DROP TABLE IF EXISTS `exam_material_category`;
CREATE TABLE `exam_material_category` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `EnName` varchar(255) DEFAULT NULL COMMENT '分类英文名称',
  `ParentId` bigint NOT NULL DEFAULT '0' COMMENT '父级编号',
  `ParentIdList` varchar(900) NOT NULL COMMENT '父级集合',
  `Sort` int NOT NULL DEFAULT '0' COMMENT '排序',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='素材分类';

-- ----------------------------
-- Records of exam_material_category
-- ----------------------------
BEGIN;
INSERT INTO `exam_material_category` VALUES (1546689436690026496, 0, '图文', 'image', 0, '[\"1546689436690026496\"]', 1, '2022-07-12 10:54:32', 'Admin', '2022-07-12 10:54:46', 'Admin');
INSERT INTO `exam_material_category` VALUES (1546689564406583296, 0, '视频', 'video', 0, '[\"1546689564406583296\"]', 2, '2022-07-12 10:55:03', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546689599580016640, 0, '文档', 'doc', 0, '[\"1546689599580016640\"]', 3, '2022-07-12 10:55:11', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546689729502777344, 0, 'JPG', 'jpg', 1546689436690026496, '[\"1546689436690026496\",\"1546689729502777344\"]', 4, '2022-07-12 10:55:42', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546694106665848832, 0, 'GIF', 'gif', 1546689436690026496, '[\"1546689436690026496\",\"1546694106665848832\"]', 5, '2022-07-12 11:13:06', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546694142527148032, 0, 'PNG', 'png', 1546689436690026496, '[\"1546689436690026496\",\"1546694142527148032\"]', 6, '2022-07-12 11:13:14', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546694255475560448, 0, 'MP4', 'mp4', 1546689564406583296, '[\"1546689564406583296\",\"1546694255475560448\"]', 7, '2022-07-12 11:13:41', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546694288270823424, 0, 'FLV', 'flv', 1546689564406583296, '[\"1546689564406583296\",\"1546694288270823424\"]', 8, '2022-07-12 11:13:49', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546694899800346624, 0, 'AVI', 'avi', 1546689564406583296, '[\"1546689564406583296\",\"1546694899800346624\"]', 9, '2022-07-12 11:16:15', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546694954573762560, 0, 'MOV', 'mov', 1546689564406583296, '[\"1546689564406583296\",\"1546694954573762560\"]', 10, '2022-07-12 11:16:28', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546695029983154176, 0, 'DOC', 'doc', 1546689599580016640, '[\"1546689599580016640\",\"1546695029983154176\"]', 11, '2022-07-12 11:16:46', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546695071599038464, 0, 'EXCEL', 'excel', 1546689599580016640, '[\"1546689599580016640\",\"1546695071599038464\"]', 12, '2022-07-12 11:16:56', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546695112451559424, 0, 'PPT', 'ppt', 1546689599580016640, '[\"1546689599580016640\",\"1546695112451559424\"]', 13, '2022-07-12 11:17:06', 'Admin', NULL, NULL);
INSERT INTO `exam_material_category` VALUES (1546695155996823552, 0, 'PDF', 'pdf', 1546689599580016640, '[\"1546689599580016640\",\"1546695155996823552\"]', 14, '2022-07-12 11:17:16', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for exam_paper
-- ----------------------------
DROP TABLE IF EXISTS `exam_paper`;
CREATE TABLE `exam_paper` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `GrandId` bigint NOT NULL DEFAULT '0' COMMENT '年级编号',
  `SubjectId` bigint NOT NULL DEFAULT '0' COMMENT '学科编号',
  `TypeId` bigint NOT NULL DEFAULT '0' COMMENT '试卷类型编号',
  `StartTime` datetime DEFAULT NULL COMMENT '考试开始时间',
  `EndTime` datetime DEFAULT NULL COMMENT '考试结束时间',
  `Title` varchar(255) NOT NULL COMMENT '试卷名称',
  `AntiCheating` varchar(100) DEFAULT '' COMMENT '防篡改',
  `MinutesLength` decimal(24,1) NOT NULL DEFAULT '0.0' COMMENT '考试时长-分钟',
  `QuestionItem` varchar(900) NOT NULL COMMENT '考试题内容',
  `Status` bit(1) NOT NULL DEFAULT b'0' COMMENT '发布状态',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='试卷';

-- ----------------------------
-- Records of exam_paper
-- ----------------------------
BEGIN;
INSERT INTO `exam_paper` VALUES (1542696503695511553, 0, 1540272019071963137, 1540271878395006976, 1542418312204521473, '2022-07-02 08:00:00', '2022-07-02 10:00:00', '测试试卷名称1112222', '[2]', 50.0, '[{\"Id\":1542011019159801857,\"Score\":20.0},{\"Id\":1542072551876988929,\"Score\":20.0}]', b'1', '2022-07-01 10:28:03', 'Admin', '2022-07-05 10:11:22', 'Admin');
INSERT INTO `exam_paper` VALUES (1602556099695874048, 0, 1540272019071963137, 1540271878395006976, 1542418255589806080, NULL, NULL, '111111111111', '[]', 0.0, '[{\"Id\":1542072551876988929,\"Score\":20.0},{\"Id\":1542011019159801857,\"Score\":15.0}]', b'1', '2022-12-13 14:48:43', '李四', '2022-12-13 14:48:58', '李四');
COMMIT;

-- ----------------------------
-- Table structure for exam_question
-- ----------------------------
DROP TABLE IF EXISTS `exam_question`;
CREATE TABLE `exam_question` (
  `Id` bigint NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `GrandId` bigint NOT NULL DEFAULT '0' COMMENT '年级编号',
  `SubjectId` bigint NOT NULL DEFAULT '0' COMMENT '学科编号',
  `Type` int DEFAULT '1' COMMENT '类型1=单选2=多选3=判断4=填空5=解答',
  `Title` varchar(255) NOT NULL COMMENT '题目',
  `SubjectItem` varchar(2000) NOT NULL COMMENT '题干',
  `Answer` varchar(1000) NOT NULL COMMENT '答案',
  `Parsing` varchar(900) DEFAULT NULL COMMENT '解析',
  `Score` decimal(24,1) NOT NULL DEFAULT '0.0' COMMENT '分数',
  `Difficulty` int NOT NULL DEFAULT '1' COMMENT '难度',
  `KnowledgePoint` varchar(255) DEFAULT NULL COMMENT '关联知识点',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='考试题';

-- ----------------------------
-- Records of exam_question
-- ----------------------------
BEGIN;
INSERT INTO `exam_question` VALUES (1539906066215735296, 0, 1540272019071963137, 1540271924658180097, 1, '下列操作方法能用来淡化海水的是', '[{\"Tag\":\"A\",\"Value\":\"沉淀法\"},{\"Tag\":\"B\",\"Value\":\"过滤法\"},{\"Tag\":\"C\",\"Value\":\"多级闪急蒸馏法\"},{\"Tag\":\"D\",\"Value\":\"电解法\"}]', 'C', '沉淀法、过滤法只能除去水中的难溶性杂质；电解水时水分子受到破坏，生成氢气和氧气。只有蒸馏法才能将水中溶有的盐类除去，成为纯净水，从而将海水淡化，选C。', 4.0, 2, '', '2022-06-23 17:39:51', 'Admin', '2022-06-29 10:38:56', 'Admin');
INSERT INTO `exam_question` VALUES (1542009421641682945, 0, 1540271986272505857, 1540271878395006976, 2, '以下哪些诗句是静夜思的？', '[{\"Tag\":\"A\",\"Value\":\"床前明月光\"},{\"Tag\":\"B\",\"Value\":\"夜来风雨声\"},{\"Tag\":\"C\",\"Value\":\"举头望明月\"},{\"Tag\":\"D\",\"Value\":\"花落有多少\"}]', 'A,C', '床前明月光，疑是地上霜。举头望明月，低头思故乡。', 20.0, 3, '', '2022-06-29 12:57:50', 'Admin', '2022-06-29 12:58:31', 'Admin');
INSERT INTO `exam_question` VALUES (1542011019159801857, 0, 1540271986272505857, 1540271878395006976, 3, '静夜思的作者是唐代的李白', '[{\"Tag\":\"A\",\"Value\":\"对\"},{\"Tag\":\"B\",\"Value\":\"错\"}]', '对', '李白的静夜思', 15.0, 1, '', '2022-06-29 13:04:11', 'Admin', '0001-01-01 00:00:00', NULL);
INSERT INTO `exam_question` VALUES (1542012282421252097, 0, 1540271986272505857, 1540271924658180097, 5, '刚刚有9本书，爸爸又给他买了5本，小明借去2本，剩下还有几本书？', '[]', '9+5-2=12', '9+5-2=12', 8.0, 5, '', '2022-06-29 13:09:12', 'Admin', '0001-01-01 00:00:00', NULL);
INSERT INTO `exam_question` VALUES (1542072551876988929, 0, 1540272019071963137, 1540271878395006976, 4, '（______），曲项向天歌。（_______），红掌拨清波。', '[]', '[{\"name\":\"鹅鹅鹅\",\"score\":10},{\"name\":\"白毛浮绿水\",\"score\":10}]', '咏鹅', 20.0, 4, '', '2022-06-29 17:08:41', 'Admin', '2022-06-29 17:20:05', 'Admin');
COMMIT;

-- ----------------------------
-- Table structure for exam_teacher
-- ----------------------------
DROP TABLE IF EXISTS `exam_teacher`;
CREATE TABLE `exam_teacher` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `ProfessionId` bigint NOT NULL DEFAULT '0' COMMENT '专业编号',
  `Name` varchar(90) NOT NULL COMMENT '教师姓名',
  `PostName` varchar(90) NOT NULL COMMENT '职称',
  `Age` int NOT NULL DEFAULT '0' COMMENT '年龄',
  `Avatar` varchar(255) NOT NULL COMMENT '头像',
  `Hits` int NOT NULL DEFAULT '0' COMMENT '访问量',
  `Focus` int NOT NULL DEFAULT '0' COMMENT '关注数',
  `Summary` longtext COMMENT '介绍',
  `CreateTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='讲师';

-- ----------------------------
-- Records of exam_teacher
-- ----------------------------
BEGIN;
INSERT INTO `exam_teacher` VALUES (1547577478409752577, 0, 1546442593481658369, '张老师', '高级职称', 20, 'http://localhost:5000/upload/knowledge/avatar-1.jpg', 11, 15, '<p>高级职称</p>', '2022-07-14 21:43:18', 'Admin', '2022-07-18 16:58:19', 'Admin');
INSERT INTO `exam_teacher` VALUES (1548955262205956097, 0, 1546442647563014145, '黄老师', '政治', 20, 'http://localhost:5000/upload/knowledge/avatar-5.jpg', 42, 4, '<p>政治</p>', '2022-07-18 16:58:07', 'Admin', '2022-07-27 15:16:18', 'Admin');
COMMIT;

-- ----------------------------
-- Table structure for exam_userlog
-- ----------------------------
DROP TABLE IF EXISTS `exam_userlog`;
CREATE TABLE `exam_userlog` (
  `Id` bigint NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `PaperId` bigint NOT NULL DEFAULT '0' COMMENT '试卷编号',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `QuestionItem` varchar(2000) NOT NULL COMMENT '题目内容',
  `UseMinutes` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '耗时分钟',
  `Status` bit(1) NOT NULL DEFAULT b'0' COMMENT '批改完成状态',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='考试记录';

-- ----------------------------
-- Records of exam_userlog
-- ----------------------------
BEGIN;
INSERT INTO `exam_userlog` VALUES (1544501376850202624, 0, 1542696503695511553, 1511955043186774017, '[{\"Id\":1542011019159801857,\"SourceScore\":20.0,\"Score\":20.0,\"Answer\":\"对\",\"Judge\":true},{\"Id\":1542072551876988929,\"SourceScore\":20.0,\"Score\":0.0,\"Answer\":\"[{\\\"name\\\":\\\"a\\\"},{\\\"name\\\":\\\"b\\\"}]\",\"Judge\":false}]', 2.00, b'1', '2022-07-06 16:37:00', 'Admin', '2022-07-06 15:55:59', 'Admin');
COMMIT;

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `GroupId` bigint NOT NULL DEFAULT '0' COMMENT '会员组编号',
  `LoginName` varchar(90) NOT NULL COMMENT '登录账号',
  `LoginPwd` varchar(255) NOT NULL COMMENT '登录密码',
  `NickName` varchar(90) NOT NULL COMMENT '真实姓名',
  `WxName` varchar(100) DEFAULT NULL COMMENT '微信昵称',
  `Mobile` varchar(32) DEFAULT NULL COMMENT '手机号码',
  `Email` varchar(32) DEFAULT NULL COMMENT '邮箱',
  `Sex` varchar(255) NOT NULL DEFAULT '1' COMMENT '性别',
  `Birthday` varchar(32) DEFAULT NULL COMMENT '生日',
  `Autograph` varchar(255) DEFAULT NULL COMMENT '签名',
  `Avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `Money` decimal(24,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `Point` int DEFAULT '0' COMMENT '积分',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '删除状态',
  `IsBlacks` bit(1) NOT NULL DEFAULT b'0' COMMENT '黑名单',
  `Status` bit(1) NOT NULL DEFAULT b'0' COMMENT '状态',
  `OpenId` varchar(150) DEFAULT NULL COMMENT '微信标识',
  `PrizeDrawNum` int NOT NULL DEFAULT '1' COMMENT '抽奖次数',
  `LoginTime` datetime DEFAULT NULL COMMENT '登录时间',
  `LoginSum` int NOT NULL DEFAULT '0' COMMENT '登录次数',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='会员表';

-- ----------------------------
-- Records of member
-- ----------------------------
BEGIN;
INSERT INTO `member` VALUES (1471403583852384257, 0, 1471788590005620738, '2222', '3333***iiii', '11111', NULL, '13511084014', '5555', '女', NULL, 'sssssss', 'https://i.gtimg.cn/club/item/face/img/2/15922_100.gif', 0.00, 0, b'0', b'0', b'1', NULL, 1, NULL, 0, '2021-12-16 16:55:26', '李四', NULL, NULL);
INSERT INTO `member` VALUES (1506196124946534400, 0, 1471783684423159808, '111', '123456AS!', '11111', NULL, '13511084024', NULL, '男', NULL, NULL, 'http://localhost:5100/upload/avatar/4.png', 0.00, 0, b'0', b'0', b'1', NULL, 1, NULL, 0, '2022-03-22 17:08:35', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for member_group
-- ----------------------------
DROP TABLE IF EXISTS `member_group`;
CREATE TABLE `member_group` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `LevelId` bigint NOT NULL DEFAULT '0' COMMENT '会员等级;关联数据字典',
  `Name` varchar(255) NOT NULL COMMENT '组名称',
  `Icon` varchar(255) DEFAULT NULL COMMENT '组图标',
  `UpPoint` int NOT NULL DEFAULT '0' COMMENT '升级积分',
  `UpMoney` decimal(24,2) NOT NULL DEFAULT '0.00' COMMENT '升级金额',
  `Status` bit(1) NOT NULL DEFAULT b'0' COMMENT '状态',
  `Summary` varchar(900) DEFAULT NULL COMMENT '描述',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='会员组';

-- ----------------------------
-- Records of member_group
-- ----------------------------
BEGIN;
INSERT INTO `member_group` VALUES (1471783684423159808, 0, 0, '钻石', NULL, 100, 500.00, b'1', '', '2021-12-17 18:05:49', NULL, '0001-01-01 00:00:00', '李四');
INSERT INTO `member_group` VALUES (1471788590005620738, 0, 0, '普通', NULL, 0, 0.00, b'1', NULL, '2021-12-17 18:25:19', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for quarz_task
-- ----------------------------
DROP TABLE IF EXISTS `quarz_task`;
CREATE TABLE `quarz_task` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `TenantId` bigint DEFAULT NULL,
  `TaskName` varchar(255) NOT NULL,
  `GroupName` varchar(255) NOT NULL,
  `Interval` varchar(255) NOT NULL,
  `ApiUrl` varchar(255) NOT NULL,
  `Describe` varchar(255) DEFAULT NULL,
  `LastRunTime` datetime DEFAULT NULL,
  `Status` int NOT NULL,
  `TaskType` int NOT NULL,
  `ApiRequestType` varchar(255) DEFAULT NULL,
  `ApiAuthKey` varchar(255) DEFAULT NULL,
  `ApiAuthValue` varchar(255) DEFAULT NULL,
  `ApiParameter` varchar(255) DEFAULT NULL,
  `DllClassName` varchar(255) DEFAULT NULL,
  `DllActionName` varchar(255) DEFAULT NULL,
  `TimeFlag` datetime DEFAULT NULL,
  `ChangeTime` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of quarz_task
-- ----------------------------
BEGIN;
INSERT INTO `quarz_task` VALUES (1, 0, 'Test_B', 'Test', '0/5 * * * * ?', '', '11111', '2022-02-22 02:18:20', 6, 1, '', '', '', '', 'TaskTest', '', '2022-02-22 02:18:20', '2022-02-22 02:18:20');
COMMIT;

-- ----------------------------
-- Table structure for quarz_task_log
-- ----------------------------
DROP TABLE IF EXISTS `quarz_task_log`;
CREATE TABLE `quarz_task_log` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `TenantId` bigint DEFAULT NULL,
  `TaskName` varchar(255) NOT NULL,
  `GroupName` varchar(255) NOT NULL,
  `BeginDate` datetime NOT NULL,
  `EndDate` datetime DEFAULT NULL,
  `Msg` varchar(255) NOT NULL,
  `TimeFlag` datetime DEFAULT NULL,
  `ChangeTime` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Table structure for shop_category
-- ----------------------------
DROP TABLE IF EXISTS `shop_category`;
CREATE TABLE `shop_category` (
  `Id` bigint NOT NULL COMMENT '唯一标识',
  `TenantId` bigint DEFAULT NULL,
  `Name` varchar(64) NOT NULL COMMENT '分类名称',
  `ParentId` bigint NOT NULL DEFAULT '1' COMMENT '分类上级',
  `ParentGroup` varchar(512) DEFAULT NULL COMMENT '分类上级组',
  `Image` varchar(200) DEFAULT NULL COMMENT '图标',
  `Layer` int NOT NULL DEFAULT '1' COMMENT '层级',
  `Code` varchar(255) DEFAULT NULL COMMENT '分类编号',
  `Sort` int DEFAULT '1' COMMENT '排序',
  `AddTime` datetime NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='商品分类表';

-- ----------------------------
-- Records of shop_category
-- ----------------------------
BEGIN;
INSERT INTO `shop_category` VALUES (1478302204191444992, 0, '水果', 0, '1478302204191444992,', '/upload/images/20220118/avatar-5.jpeg', 1, NULL, 2, '2022-01-04 17:48:06');
INSERT INTO `shop_category` VALUES (1478302233182474242, 0, '蔬菜', 0, '1478302233182474242,', '/upload/images/20220118/avatar-5.jpeg', 1, NULL, 3, '2022-01-04 17:48:13');
INSERT INTO `shop_category` VALUES (1478302282675261441, 0, '食品', 0, '1478302282675261441,', '/upload/images/20220118/avatar-5.jpeg', 1, NULL, 4, '2022-01-04 17:48:24');
INSERT INTO `shop_category` VALUES (1478303162078203904, 0, '甜瓜', 1478302204191444992, '1478302204191444992,1478303162078203904,', NULL, 2, NULL, 5, '2022-01-04 17:51:54');
INSERT INTO `shop_category` VALUES (1478303197876588546, 0, '柑橘', 1478302204191444992, '1478302204191444992,1478303197876588546,', NULL, 2, NULL, 6, '2022-01-04 17:52:03');
INSERT INTO `shop_category` VALUES (1478303240830455810, 0, '车厘子', 1478302204191444992, '1478302204191444992,1478303240830455810,', NULL, 2, NULL, 7, '2022-01-04 17:52:13');
INSERT INTO `shop_category` VALUES (1478311477726285826, 0, '生鲜', 0, '1478311477726285826,', '/upload/images/20220118/avatar-5.jpeg', 1, NULL, 8, '2022-01-04 18:24:57');
INSERT INTO `shop_category` VALUES (1478311536207466498, 0, '苹果', 1478302204191444992, '1478302204191444992,1478311536207466498,', NULL, 2, NULL, 9, '2022-01-04 18:25:11');
INSERT INTO `shop_category` VALUES (1478311850310504450, 0, '饼干蛋糕', 1478302282675261441, '1478302282675261441,1478311850310504450,', NULL, 2, NULL, 10, '2022-01-04 18:26:25');
INSERT INTO `shop_category` VALUES (1478311903578165250, 0, '面包', 1478302282675261441, '1478302282675261441,1478311903578165250,', NULL, 2, NULL, 11, '2022-01-04 18:26:38');
INSERT INTO `shop_category` VALUES (1478311963024035842, 0, '坚果炒货', 1478302282675261441, '1478302282675261441,1478311963024035842,', NULL, 2, NULL, 12, '2022-01-04 18:26:52');
INSERT INTO `shop_category` VALUES (1478312022134362114, 0, '肉干肉铺', 1478302282675261441, '1478302282675261441,1478312022134362114,', NULL, 2, NULL, 13, '2022-01-04 18:27:06');
INSERT INTO `shop_category` VALUES (1478312061414019074, 0, '酒水', 1478302282675261441, '1478302282675261441,1478312061414019074,', NULL, 2, NULL, 14, '2022-01-04 18:27:16');
INSERT INTO `shop_category` VALUES (1478312090732204034, 0, '饮料', 1478302282675261441, '1478302282675261441,1478312090732204034,', NULL, 2, NULL, 15, '2022-01-04 18:27:23');
INSERT INTO `shop_category` VALUES (1478312133124034562, 0, '酱菜咸菜', 1478302282675261441, '1478302282675261441,1478312133124034562,', NULL, 2, NULL, 16, '2022-01-04 18:27:33');
INSERT INTO `shop_category` VALUES (1478312173099945986, 0, '休闲食品', 1478302282675261441, '1478302282675261441,1478312173099945986,', NULL, 2, NULL, 17, '2022-01-04 18:27:42');
INSERT INTO `shop_category` VALUES (1478312233141407746, 0, '海鲜', 1478311477726285826, '1478311477726285826,1478312233141407746,', NULL, 2, NULL, 18, '2022-01-04 18:27:57');
INSERT INTO `shop_category` VALUES (1478312283783434242, 0, '速冻食品', 1478311477726285826, '1478311477726285826,1478312283783434242,', NULL, 2, NULL, 19, '2022-01-04 18:28:09');
INSERT INTO `shop_category` VALUES (1478312335172046848, 0, '乳制品', 1478311477726285826, '1478311477726285826,1478312335172046848,', NULL, 2, NULL, 20, '2022-01-04 18:28:21');
INSERT INTO `shop_category` VALUES (1478312409369284610, 0, '河鲜', 1478311477726285826, '1478311477726285826,1478312409369284610,', NULL, 2, NULL, 21, '2022-01-04 18:28:39');
INSERT INTO `shop_category` VALUES (1478312472183181314, 0, '茄果', 1478302233182474242, '1478302233182474242,1478312472183181314,', NULL, 2, NULL, 22, '2022-01-04 18:28:54');
INSERT INTO `shop_category` VALUES (1478312505406263298, 0, '叶菜', 1478302233182474242, '1478302233182474242,1478312505406263298,', NULL, 2, NULL, 23, '2022-01-04 18:29:02');
INSERT INTO `shop_category` VALUES (1478312563648368642, 0, '根菜', 1478302233182474242, '1478302233182474242,1478312563648368642,', NULL, 2, NULL, 24, '2022-01-04 18:29:16');
INSERT INTO `shop_category` VALUES (1478312628123209730, 0, '豆荚', 1478302233182474242, '1478302233182474242,1478312628123209730,', NULL, 2, NULL, 25, '2022-01-04 18:29:31');
INSERT INTO `shop_category` VALUES (1478312664794009602, 0, '菌类', 1478302233182474242, '1478302233182474242,1478312664794009602,', NULL, 2, NULL, 26, '2022-01-04 18:29:40');
INSERT INTO `shop_category` VALUES (1478312697790599170, 0, '特菜', 1478302233182474242, '1478302233182474242,1478312697790599170,', NULL, 2, NULL, 27, '2022-01-04 18:29:48');
INSERT INTO `shop_category` VALUES (1478312745370783746, 0, '葱姜蒜', 1478302233182474242, '1478302233182474242,1478312745370783746,', NULL, 2, NULL, 28, '2022-01-04 18:29:59');
INSERT INTO `shop_category` VALUES (1478312818221649922, 0, '瓜类', 1478302233182474242, '1478302233182474242,1478312818221649922,', NULL, 2, NULL, 29, '2022-01-04 18:30:16');
COMMIT;

-- ----------------------------
-- Table structure for shop_goods
-- ----------------------------
DROP TABLE IF EXISTS `shop_goods`;
CREATE TABLE `shop_goods` (
  `Id` bigint NOT NULL COMMENT '唯一标识',
  `TenantId` bigint DEFAULT NULL,
  `CategoryId` varchar(200) NOT NULL DEFAULT '0' COMMENT '商品分类',
  `StoreId` bigint NOT NULL DEFAULT '0' COMMENT '商户编号',
  `GradeId` bigint NOT NULL DEFAULT '0' COMMENT '等级',
  `CityId` varchar(200) NOT NULL DEFAULT '0' COMMENT '产地',
  `Tags` varchar(255) DEFAULT NULL COMMENT '商品标签',
  `Name` varchar(200) NOT NULL COMMENT '商品名称',
  `Number` varchar(255) DEFAULT NULL COMMENT '商品货号',
  `Attribute` varchar(255) DEFAULT NULL COMMENT '商品属性',
  `Picture` varchar(1000) DEFAULT NULL COMMENT '商品相册',
  `Stock` int NOT NULL DEFAULT '0' COMMENT '库存',
  `Sale` int NOT NULL DEFAULT '0' COMMENT '总销售数',
  `Price` decimal(24,1) DEFAULT '0.0' COMMENT '商品价格',
  `UnitPrice` decimal(24,1) DEFAULT '0.0' COMMENT '商品净单价',
  `Weight` varchar(255) NOT NULL COMMENT '商品重量',
  `Unit` varchar(255) DEFAULT NULL COMMENT '商品单位',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态（上下架）',
  `Sort` int DEFAULT '1' COMMENT '排序',
  `Specs` varchar(2000) DEFAULT NULL COMMENT '商品规格',
  `Summary` varchar(4000) DEFAULT NULL COMMENT '商品描述',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '添加人',
  `AddTime` datetime NOT NULL COMMENT '添加时间',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='商品表';

-- ----------------------------
-- Records of shop_goods
-- ----------------------------
BEGIN;
INSERT INTO `shop_goods` VALUES (1478993909546881024, 0, '[\"1478302233182474242\",\"1478312563648368642\"]', 1478921372011991040, 1477858125406146561, '[\"1356886169916411904\",\"1356888899892416512\"]', '[\"1478645580069736448\"]', '西红柿', '1001', '[2]', '[{\"Name\":\"3.png\",\"Url\":\"/upload/images/20220118/3.png\"}]', 100, 0, 12.6, 1.2, '5', '件', b'1', 1, '[]', NULL, '李四', '2022-01-06 15:36:41', '2022-01-18 14:13:54', '李四');
INSERT INTO `shop_goods` VALUES (1479368493731287040, 0, '[\"1478302204191444992\",\"1478311536207466498\"]', 1478921372011991040, 1477858087078596608, '[\"1356889133003444224\",\"1356889264092221440\",\"1356889350817845248\"]', '[\"1478645580069736448\"]', '水汪汪的大苹果', '1002', '[4]', '[{\"Name\":\"1.png\",\"Url\":\"/upload/images/20220118/1.png\"},{\"Name\":\"2.png\",\"Url\":\"/upload/images/20220118/2.png\"}]', 25, 0, 5.5, 5.0, '2', '件', b'1', 1, '[{\"Name\":\"规格\",\"Summary\":\"4✖️4 16个\"},{\"Name\":\"描述\",\"Summary\":\"水多，脆甜\"}]', NULL, '李四', '2022-01-07 16:25:09', '2022-01-18 14:11:40', '李四');
INSERT INTO `shop_goods` VALUES (1483321983319019520, 0, '[\"1478302233182474242\",\"1478312563648368642\"]', 1479376828283097088, 1477858107760709634, '[\"1356889133003444224\",\"1356889264092221440\",\"1356889350817845248\"]', '[]', '青椒', '10021', '[]', '[{\"Name\":\"4.png\",\"Url\":\"/upload/images/20220118/4.png\"}]', 24, 0, 12.0, 5.0, '3.5', '件', b'1', 1, '[{\"Name\":\"规格\",\"Summary\":\"1✖️1\"},{\"Name\":\"描述\",\"Summary\":\"好吃不贵\"}]', NULL, '李四', '2022-01-18 14:14:54', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for shop_order
-- ----------------------------
DROP TABLE IF EXISTS `shop_order`;
CREATE TABLE `shop_order` (
  `Id` bigint NOT NULL COMMENT '唯一标识',
  `TenantId` bigint DEFAULT NULL,
  `MemberId` bigint NOT NULL DEFAULT '0' COMMENT '用户标识',
  `GoodsId` bigint NOT NULL DEFAULT '0' COMMENT '商品标识',
  `Purchase` decimal(24,1) NOT NULL DEFAULT '0.0' COMMENT '代采费',
  `Freight` decimal(24,1) NOT NULL DEFAULT '0.0' COMMENT '运费',
  `Price` decimal(24,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额',
  `PayPrice` decimal(24,2) NOT NULL DEFAULT '0.00' COMMENT '结算金额',
  `DeliveryType` varchar(255) DEFAULT NULL COMMENT '配送方式',
  `ReserveTime` varchar(255) DEFAULT NULL COMMENT '预定日期',
  `PayStatus` bit(1) NOT NULL DEFAULT b'0' COMMENT '支付状态',
  `PayTime` datetime DEFAULT NULL COMMENT '支付时间',
  `Status` int NOT NULL DEFAULT '1' COMMENT '订单状态',
  `Summary` varchar(900) DEFAULT NULL COMMENT '订单备注',
  `AddTime` datetime NOT NULL COMMENT '添加时间',
  `SuccessTime` datetime DEFAULT NULL COMMENT '完成时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='商品订单表';

-- ----------------------------
-- Table structure for shop_order_goods
-- ----------------------------
DROP TABLE IF EXISTS `shop_order_goods`;
CREATE TABLE `shop_order_goods` (
  `Id` bigint NOT NULL COMMENT '唯一标识',
  `TenantId` bigint DEFAULT NULL,
  `OrderId` bigint NOT NULL DEFAULT '0' COMMENT '订单编号',
  `GoodsId` bigint NOT NULL DEFAULT '0' COMMENT '商品标识',
  `Price` decimal(24,1) DEFAULT '0.0' COMMENT '商品金额',
  `Count` int NOT NULL DEFAULT '0' COMMENT '数量',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='商品订单详细表';

-- ----------------------------
-- Table structure for shop_points_goods
-- ----------------------------
DROP TABLE IF EXISTS `shop_points_goods`;
CREATE TABLE `shop_points_goods` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Title` varchar(100) NOT NULL COMMENT '商品名称',
  `Number` varchar(20) NOT NULL COMMENT '商品编号',
  `Point` int NOT NULL DEFAULT '0' COMMENT '兑换需要积分',
  `Price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '原价',
  `Specs` varchar(200) DEFAULT NULL COMMENT '属性',
  `ImgUrls` varchar(500) DEFAULT NULL COMMENT '商品图片',
  `Stock` int NOT NULL DEFAULT '0' COMMENT '库存',
  `Limits` int NOT NULL DEFAULT '0' COMMENT '限购数量',
  `Sales` int NOT NULL DEFAULT '0' COMMENT '销售数量',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '上架状态',
  `Details` longtext,
  `CreateTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='积分商城-商品表';

-- ----------------------------
-- Records of shop_points_goods
-- ----------------------------
BEGIN;
INSERT INTO `shop_points_goods` VALUES (1506873967955283968, 0, '汽车掸子可伸缩子母掸 洗车拖把洗车刷 擦车用除尘掸子刷车工具 灰色(含收纳袋)', 'MUVCBP', 500, 50.00, '[{\"Name\":\"品牌\",\"Value\":\"卡饰社（CarSetCity）\"},{\"Name\":\"手柄材质\",\"Value\":\"不锈钢\"},{\"Name\":\"包装规格\",\"Value\":\"子母掸\"}]', '/upload/shop/s1.jpg,/upload/shop/s11.jpg', 500, 5, 0, b'1', '<p><img src=\"http://localhost:5100/upload/artice/s1-1.jpg\" alt=\"\" width=\"735\" height=\"6890\" /></p>', '2022-03-24 14:02:05');
INSERT INTO `shop_points_goods` VALUES (1509727652028747776, 0, '汽车香薰车载香水', 'F6XP4X', 1000, 100.00, '[{\"Name\":\"品牌\",\"Value\":\" 轩之梦\"},{\"Name\":\"挥发时长\",\"Value\":\"90日以上\"}]', '/upload/shop/s2.jpg,/upload/shop/s22.jpg', 50, 5, 0, b'1', '<p><img src=\"http://localhost:5100/upload/artice/s2-2.jpg\" alt=\"\" width=\"771\" height=\"9184\" /></p>', '2022-04-01 11:01:36');
INSERT INTO `shop_points_goods` VALUES (1509728677712236544, 0, '汽车后视镜防雨膜汽车防雨贴膜倒车镜防水膜汽车用品', 'CGA9OU', 300, 30.00, '[{\"Name\":\"品牌\",\"Value\":\"倍思（Baseus）\"}]', '/upload/shop/s3.jpg,/upload/shop/s33.jpg', 100, 5, 0, b'1', '<p><img src=\"http://localhost:5100/upload/artice/s3-3.jpg\" alt=\"\" width=\"726\" height=\"10913\" /></p>', '2022-04-01 11:05:41');
INSERT INTO `shop_points_goods` VALUES (1509729854952706048, 0, '挪车电话牌 临时停车号码牌汽车隐藏式移车电话号码牌', '10W4YV', 400, 40.00, '[{\"Name\":\"品牌\",\"Value\":\"绿联（UGREEN）\"},{\"Name\":\"类型\",\"Value\":\"夜光式，隐藏式\"},{\"Name\":\"功能\",\"Value\":\"太阳能充电\"}]', '/upload/shop/s4.jpg,/upload/shop/s44.jpg', 100, 2, 0, b'1', '<p><img src=\"http://localhost:5100/upload/artice/s4-4.jpg\" alt=\"\" width=\"725\" height=\"12875\" /></p>', '2022-04-01 11:10:22');
INSERT INTO `shop_points_goods` VALUES (1509730871748464640, 0, '360行车记录仪G300升级版G300 3k高清', 'SZJYPE', 3300, 330.00, '[{\"Name\":\"品牌\",\"Value\":\"360\"},{\"Name\":\"拍摄角度\",\"Value\":\"90°-150°\"},{\"Name\":\"拍照像素\",\"Value\":\"200万\"},{\"Name\":\"功能\",\"Value\":\"停车监控，电子狗，Wi-Fi\"}]', '/upload/shop/s5.jpg,/upload/shop/s55.jpg', 10, 2, 0, b'1', '<p><img src=\"http://localhost:5100/upload/artice/s5-5.jpg\" alt=\"\" width=\"726\" height=\"9197\" /></p>', '2022-04-01 11:14:24');
COMMIT;

-- ----------------------------
-- Table structure for shop_points_log
-- ----------------------------
DROP TABLE IF EXISTS `shop_points_log`;
CREATE TABLE `shop_points_log` (
  `Id` bigint NOT NULL,
  `TenantId` bigint DEFAULT NULL,
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '会员编号',
  `Flag` int NOT NULL DEFAULT '1' COMMENT '增加还是减少——1=增加 2=减少',
  `GetType` int NOT NULL DEFAULT '0' COMMENT '获得积分方式',
  `Point` int NOT NULL DEFAULT '0' COMMENT '积分数',
  `AddTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='商品积分增加减少日志';

-- ----------------------------
-- Records of shop_points_log
-- ----------------------------
BEGIN;
INSERT INTO `shop_points_log` VALUES (1509822953485897728, 0, 1471403583852384257, 2, 4, 0, '2022-04-01 17:20:18');
INSERT INTO `shop_points_log` VALUES (1509826034357374977, 0, 1471403583852384257, 2, 4, 3300, '2022-04-01 17:32:32');
INSERT INTO `shop_points_log` VALUES (1511528287149625344, 0, 1471403583852384257, 2, 4, 3300, '2022-04-06 10:16:41');
INSERT INTO `shop_points_log` VALUES (1511969095686426624, 0, 1511955043186774017, 2, 4, 400, '2022-04-07 15:28:18');
INSERT INTO `shop_points_log` VALUES (1514514642385375232, 0, 1511955043186774017, 1, 1, 500, '2022-04-14 16:03:24');
COMMIT;

-- ----------------------------
-- Table structure for shop_points_order
-- ----------------------------
DROP TABLE IF EXISTS `shop_points_order`;
CREATE TABLE `shop_points_order` (
  `Id` bigint NOT NULL,
  `TenantId` bigint DEFAULT NULL,
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户信息',
  `GoodsId` bigint NOT NULL DEFAULT '0' COMMENT '商品信息',
  `Point` int NOT NULL DEFAULT '0' COMMENT '支付积分',
  `Count` int NOT NULL DEFAULT '1' COMMENT '兑换数量',
  `Status` int NOT NULL DEFAULT '0' COMMENT '订单状态',
  `CreateTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '订单日期',
  `SuccessTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '确认订单日期',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='积分商城-订单表';

-- ----------------------------
-- Records of shop_points_order
-- ----------------------------
BEGIN;
INSERT INTO `shop_points_order` VALUES (1509743790011846656, 0, 1506196124946534400, 1509730871748464640, 3300, 1, 1, '2022-04-01 12:11:43', '2022-04-01 12:11:43');
INSERT INTO `shop_points_order` VALUES (1509745440491442176, 0, 1471403583852384257, 1509729854952706048, 400, 1, 0, '2022-04-01 12:12:17', NULL);
INSERT INTO `shop_points_order` VALUES (1509772373824507904, 0, 1471403583852384257, 1509727652028747776, 1000, 1, 0, '2022-04-01 13:59:19', NULL);
INSERT INTO `shop_points_order` VALUES (1511969095682232320, 0, 1511955043186774017, 1509729854952706048, 400, 1, 0, '2022-04-07 15:28:18', NULL);
COMMIT;

-- ----------------------------
-- Table structure for shop_setting
-- ----------------------------
DROP TABLE IF EXISTS `shop_setting`;
CREATE TABLE `shop_setting` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Purchase` decimal(24,1) NOT NULL DEFAULT '0.0' COMMENT '代采费',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='商城设置表';

-- ----------------------------
-- Table structure for shop_store
-- ----------------------------
DROP TABLE IF EXISTS `shop_store`;
CREATE TABLE `shop_store` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `Name` varchar(90) NOT NULL DEFAULT '0' COMMENT '店铺名称',
  `Types` varchar(90) NOT NULL COMMENT '店铺类型（个人/企业）',
  `Shopkeeper` varchar(255) NOT NULL COMMENT '店主',
  `Phone` varchar(50) DEFAULT NULL COMMENT '联系方式',
  `Account` varchar(90) NOT NULL COMMENT '用户名',
  `PassWord` varchar(255) NOT NULL COMMENT '密码',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `Attestation` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否认证',
  `Summary` varchar(500) DEFAULT NULL COMMENT '描述',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='商家表';

-- ----------------------------
-- Records of shop_store
-- ----------------------------
BEGIN;
INSERT INTO `shop_store` VALUES (1478921372011991040, 0, '永辉', '企业', '张三', '13888878766', 'zhangsan', '2F98B08B4C7603279F3E31D711AF499D', b'1', b'0', NULL, '2022-01-06 10:48:27', NULL, NULL, NULL);
INSERT INTO `shop_store` VALUES (1479376828283097088, 0, '京东', '企业', '刘哥', '13888889898', 'jdadmin', '6B43D31A0FF79FDC987CAF0C0C71590B', b'1', b'0', NULL, '2022-01-07 16:58:16', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_admin
-- ----------------------------
DROP TABLE IF EXISTS `sys_admin`;
CREATE TABLE `sys_admin` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户',
  `PostGroup` varchar(200) DEFAULT NULL COMMENT '所属岗位',
  `OrganizeId` bigint NOT NULL COMMENT '所属部门',
  `OrganizeIdList` varchar(200) DEFAULT NULL COMMENT '所属上级部门组',
  `LoginAccount` varchar(30) NOT NULL COMMENT '登录账号',
  `LoginPassWord` varchar(200) NOT NULL COMMENT '登录密码',
  `Avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `FullName` varchar(20) NOT NULL COMMENT '姓名',
  `Mobile` varchar(50) DEFAULT NULL COMMENT '手机号码',
  `Email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `Sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `Summary` varchar(200) DEFAULT NULL COMMENT '备注',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  `LoginTime` datetime DEFAULT NULL COMMENT '登录时间',
  `UpLoginTime` datetime DEFAULT NULL COMMENT '上次登录时间',
  `LoginCount` int NOT NULL DEFAULT '0' COMMENT '登录次数',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='管理员表';

-- ----------------------------
-- Records of sys_admin
-- ----------------------------
BEGIN;
INSERT INTO `sys_admin` VALUES (1260380358965334016, 0, '[\"1251019168074043392\"]', 1247889786656657408, '[\"1247889786656657408\"]', 'admin', 'to6xiR42IhqiLup1QmKgwmYlFNSw12Ntb1805Ekr70Kdz5BriNI/8OJLZbHKvfzj', '/upload/avatar/6.jpg', '李四', '13511111111', '222@qq.com', '男', b'1', b'0', '正所谓富贵险中求', '2020-05-13 09:24:29', 'admin', '2023-02-06 15:05:28', '李四', '2023-02-06 15:05:28', '2023-02-06 15:05:28', 642);
INSERT INTO `sys_admin` VALUES (1519584258979663873, 0, '[\"1251019232876040192\"]', 1248157435479330816, '[\"1247889786656657408\",\"1248157435479330816\"]', 'fyadmin1', '1r8TzFYS+pN1FzU+U7EVfpQRPWj8kehQtN5o1HKJessuwMNAeOvWQpIpeYyk6heZ', '', 'fyadmin', '13777373733', '', '男', b'1', b'0', '', '2022-04-28 15:48:14', 'Admin', '2022-11-03 17:27:54', 'fyadmin', '2022-11-03 17:27:54', '2022-11-03 17:27:54', 11);
INSERT INTO `sys_admin` VALUES (1588429900128325632, 1588429898672902144, '[]', 1588429899922804736, '[]', 'fyadmin', 'hfMwLF3l2tIyfnjl5scUu//gz2RAw4en5pysJMHjr1UHz9g+TBQON/G6wtaTUqyG', '/upload/avatar/6.jpg', 'fyadmin', NULL, NULL, NULL, b'1', b'0', NULL, '2022-11-04 15:16:14', '李四', '2022-12-16 14:07:01', '李四', '2022-12-16 14:07:01', '2022-12-16 14:07:01', 7);
INSERT INTO `sys_admin` VALUES (1592090369141641216, 0, '[\"1251019168074043392\"]', 1248157435479330816, '[\"1247889786656657408\",\"1248157435479330816\"]', 'admin_fy', 'hfMwLF3l2tIyfnjl5scUu//gz2RAw4en5pysJMHjr1UHz9g+TBQON/G6wtaTUqyG', NULL, 'admin_fy', '1355555656', '', '男', b'1', b'0', '', '2022-11-14 17:41:38', '李四', '2022-11-17 17:22:51', 'fyadmin', '2022-11-17 17:22:51', '2022-11-17 17:22:51', 3);
COMMIT;

-- ----------------------------
-- Table structure for sys_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_admin_role`;
CREATE TABLE `sys_admin_role` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  `AdminId` bigint NOT NULL COMMENT '用户编号',
  `RoleId` bigint NOT NULL COMMENT '角色编号',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户角色关系表';

-- ----------------------------
-- Records of sys_admin_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_admin_role` VALUES (1620979563876192256, 0, 1260380358965334016, 1339756014718816256, '2023-02-06 14:38:29', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_adv_column
-- ----------------------------
DROP TABLE IF EXISTS `sys_adv_column`;
CREATE TABLE `sys_adv_column` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `ParentId` bigint NOT NULL DEFAULT '0' COMMENT '父编号',
  `ParentIdList` varchar(128) NOT NULL COMMENT '父编号集合',
  `Layer` int NOT NULL DEFAULT '1' COMMENT '层级',
  `Name` varchar(32) NOT NULL COMMENT '栏目名称',
  `Flag` varchar(50) DEFAULT NULL COMMENT '栏目类型',
  `Width` int NOT NULL DEFAULT '0' COMMENT '栏目宽度',
  `Height` int NOT NULL DEFAULT '0' COMMENT '栏目高度',
  `Sort` int DEFAULT NULL COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '栏目状态',
  `Summary` varchar(512) DEFAULT NULL COMMENT '栏目说明',
  `SiteId` bigint NOT NULL DEFAULT '0' COMMENT '站点ID',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='广告位栏目表 ';

-- ----------------------------
-- Records of sys_adv_column
-- ----------------------------
BEGIN;
INSERT INTO `sys_adv_column` VALUES (1366296925808234496, 0, 0, '[\"1366296925808234496\"]', 1, '小程序', 'C', 0, 0, 0, b'1', NULL, 0, '2021-03-01 15:59:06', NULL, '0001-01-01 00:00:00', NULL);
INSERT INTO `sys_adv_column` VALUES (1548931126742093824, 0, 0, '[\"0\"]', 1, '课程', 'exam', 0, 0, 3, b'1', NULL, 0, '2022-07-18 15:22:13', 'Admin', NULL, NULL);
INSERT INTO `sys_adv_column` VALUES (1548931502119718914, 0, 1548931126742093824, '[\"1548931126742093824\",\"0\"]', 2, '首页轮播图', 'exam-index', 1920, 350, 4, b'1', NULL, 0, '2022-07-18 15:23:43', 'Admin', NULL, NULL);
INSERT INTO `sys_adv_column` VALUES (1579045488185970688, 0, 1366296925808234496, '[\"1366296925808234496\",\"0\"]', 2, '社区', NULL, 0, 0, 6, b'1', NULL, 0, '2022-10-09 17:45:56', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_adv_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_adv_info`;
CREATE TABLE `sys_adv_info` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint DEFAULT NULL,
  `ColumnId` bigint NOT NULL DEFAULT '0' COMMENT '栏目Id',
  `Title` varchar(128) NOT NULL COMMENT '广告名称',
  `Types` int NOT NULL DEFAULT '1' COMMENT '广告位类型',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `ImgUrl` varchar(128) DEFAULT NULL COMMENT '广告位图片',
  `LinkUrl` varchar(128) DEFAULT NULL COMMENT '连接地址',
  `Target` varchar(32) NOT NULL COMMENT '跳转方式',
  `Summary` varchar(512) DEFAULT NULL COMMENT '描述',
  `Codes` varchar(512) DEFAULT NULL COMMENT '广告位代码',
  `IsTimeLimit` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否开启时间限制',
  `BeginTime` datetime DEFAULT NULL COMMENT '开始时间',
  `EndTime` datetime DEFAULT NULL COMMENT '结束时间',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `Hits` int NOT NULL DEFAULT '0' COMMENT '广告点击率',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='广告位信息表 ';

-- ----------------------------
-- Records of sys_adv_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_adv_info` VALUES (1548931988470239232, 0, 1548931502119718914, 'Enjoy Watching', 1, b'1', '/upload/adv/img2.jpg', 'javascript:void(0)', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2022-07-18 15:25:38', 'Admin', '2022-08-04 14:14:23', 'Admin');
INSERT INTO `sys_adv_info` VALUES (1548932080245805057, 0, 1548931502119718914, 'Discover Life', 1, b'1', '/upload/adv/img3.jpg', 'javascript:void(0)', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2022-07-18 15:26:00', 'Admin', '2022-08-04 14:14:36', 'Admin');
INSERT INTO `sys_adv_info` VALUES (1579045629685010432, 0, 1579045488185970688, '活动一', 1, b'1', '/upload/adv/dt3.jpg', '1', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2022-10-09 17:46:30', 'Admin', NULL, NULL);
INSERT INTO `sys_adv_info` VALUES (1579045657082204161, 0, 1579045488185970688, '活动二', 1, b'1', '/upload/adv/dt2.jpg', '2', '_blank', NULL, NULL, b'0', NULL, NULL, 1, 0, '2022-10-09 17:46:37', 'Admin', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_calendar
-- ----------------------------
DROP TABLE IF EXISTS `sys_calendar`;
CREATE TABLE `sys_calendar` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `Title` varchar(255) NOT NULL COMMENT '日程标题',
  `TypeId` bigint NOT NULL DEFAULT '0' COMMENT '日程类型',
  `LevelId` bigint NOT NULL DEFAULT '0' COMMENT '日程等级',
  `StartTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始时间',
  `EndTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '结束时间',
  `UserIds` varchar(900) DEFAULT NULL COMMENT '参与人列表',
  `ToBusiness` varchar(900) DEFAULT NULL COMMENT '关联业务',
  `Remind` varchar(255) DEFAULT NULL COMMENT '提醒设置',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='日程表';

-- ----------------------------
-- Records of sys_calendar
-- ----------------------------
BEGIN;
INSERT INTO `sys_calendar` VALUES (1560240425795719169, '日程A', 1560170162378903553, 1560170378628829184, '2022-08-18 20:21:12', '2022-08-30 00:00:00', '[{\"Id\":1260380358965334016,\"FullName\":\"李四\"},{\"Id\":1519584258979663873,\"FullName\":\"testrole\"}]', '[]', '{\"Number\":0,\"TimeType\":0}', '2022-08-18 20:21:20', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_calendar` VALUES (1560240672399822849, '20日程11111', 1560170162378903553, 1560170655905878017, '2022-08-20 00:00:00', '2022-08-31 00:00:00', '[{\"Id\":1260380358965334016,\"FullName\":\"李四\"}]', '[]', '{\"Number\":0,\"TimeType\":0}', '2022-08-18 20:22:19', 'Admin', '2022-08-18 22:04:15', 'Admin', 0);
INSERT INTO `sys_calendar` VALUES (1560252425619771392, '紧急日程', 1560170162378903553, 1560170714076680193, '2022-08-18 21:08:53', '2022-08-31 00:00:00', '[{\"Id\":1260380358965334016,\"FullName\":\"李四\"}]', '[]', '{\"Number\":0,\"TimeType\":0}', '2022-08-18 21:09:01', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_calendar` VALUES (1560262246821662720, '日程19日程19日程19日程19日程19日程19日程19日程19日程19', 1560170208142954497, 1560170714076680193, '2022-08-19 00:00:00', '2022-08-31 00:00:00', '[{\"Id\":1260380358965334016,\"FullName\":\"李四\"},{\"Id\":1519584258979663873,\"FullName\":\"testrole\"}]', '[]', '{\"Number\":0,\"TimeType\":0}', '2022-08-18 21:48:03', 'Admin', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_city
-- ----------------------------
DROP TABLE IF EXISTS `sys_city`;
CREATE TABLE `sys_city` (
  `Id` bigint NOT NULL COMMENT '唯一标识',
  `Name` varchar(64) NOT NULL COMMENT '城市名称',
  `ParentId` bigint NOT NULL DEFAULT '1' COMMENT '所属上级',
  `ParentIdList` varchar(512) DEFAULT NULL COMMENT '所属上级组',
  `Layer` int NOT NULL DEFAULT '1' COMMENT '层级',
  `Code` varchar(32) DEFAULT NULL COMMENT '城市编号',
  `Longitude` varchar(64) DEFAULT NULL COMMENT '经度',
  `Dimension` varchar(64) DEFAULT NULL COMMENT '维度',
  `Sort` int DEFAULT '1' COMMENT '排序',
  `AddTime` datetime NOT NULL COMMENT '添加时间',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='城市表';

-- ----------------------------
-- Records of sys_city
-- ----------------------------
BEGIN;
INSERT INTO `sys_city` VALUES (1505158225400565760, '北京', 0, '[\"1505158225400565760\"]', 1, '100000', NULL, NULL, 2, '2022-03-19 20:24:20', 0);
INSERT INTO `sys_city` VALUES (1505160686236471296, '上海', 0, '[\"1505160686236471296\"]', 1, '322000', NULL, NULL, 3, '2022-03-19 20:34:07', 0);
INSERT INTO `sys_city` VALUES (1589877328526315520, '海淀区', 1505158225400565760, '[\"1505158225400565760\",\"0\"]', 2, '100101', NULL, NULL, 4, '2022-11-08 15:07:48', 0);
INSERT INTO `sys_city` VALUES (1589877380762177538, '朝阳区', 1505158225400565760, '[\"1505158225400565760\",\"0\"]', 2, '10011', NULL, NULL, 5, '2022-11-08 15:08:01', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_code
-- ----------------------------
DROP TABLE IF EXISTS `sys_code`;
CREATE TABLE `sys_code` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TypeId` bigint NOT NULL COMMENT '分类编号',
  `Tag` int NOT NULL DEFAULT '1' COMMENT '对应CodeType的Type',
  `Name` varchar(50) NOT NULL COMMENT '字典值名称',
  `CodeValues` varchar(50) DEFAULT NULL COMMENT '字典值阈值',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `Summary` varchar(100) DEFAULT NULL COMMENT '备注',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='字典信息表';

-- ----------------------------
-- Records of sys_code
-- ----------------------------
BEGIN;
INSERT INTO `sys_code` VALUES (1540271878395006976, 1540271653957799938, 1, '语文', 'A', 1, b'1', b'0', NULL, '2022-06-24 17:53:27', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1540271924658180097, 1540271653957799938, 1, '数学', 'B', 1, b'1', b'0', NULL, '2022-06-24 17:53:38', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1540271954144137217, 1540271653957799938, 1, '历史', 'C', 1, b'1', b'0', NULL, '2022-06-24 17:53:45', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1540271986272505857, 1540271598412632064, 1, '小学', 'A', 1, b'1', b'0', NULL, '2022-06-24 17:53:53', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1540272019071963137, 1540271598412632064, 1, '中学', 'B', 1, b'1', b'0', NULL, '2022-06-24 17:54:01', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1540272044145512449, 1540271598412632064, 1, '高中', 'C', 1, b'1', b'0', NULL, '2022-06-24 17:54:07', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1540272093231452160, 1540271598412632064, 1, '大学', NULL, 1, b'1', b'0', NULL, '2022-06-24 17:54:19', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1540272135673614336, 1540271598412632064, 1, '研究生', 'D', 1, b'1', b'0', NULL, '2022-06-24 17:54:29', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1542418255589806080, 1542418195795808256, 2, '固定试卷', 'A', 1, b'1', b'0', NULL, '2022-06-30 16:02:24', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1542418312204521473, 1542418195795808256, 1, '时段试卷', 'B', 1, b'1', b'0', NULL, '2022-06-30 16:02:37', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1542418379355328513, 1542418195795808256, 1, '作业试卷', 'C', 1, b'1', b'0', NULL, '2022-06-30 16:02:53', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1542418409352990720, 1542418195795808256, 1, '班级试卷', 'D', 1, b'1', b'0', NULL, '2022-06-30 16:03:00', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1546442544722874369, 1546442332772110336, 2, '机化学', 'A', 1, b'1', b'0', NULL, '2022-07-11 18:33:29', 'Admin', '2022-07-11 18:33:44', 'Admin', 0);
INSERT INTO `sys_code` VALUES (1546442593481658369, 1546442332772110336, 1, '植物学', 'B', 1, b'1', b'0', NULL, '2022-07-11 18:33:40', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1546442647563014145, 1546442332772110336, 1, '政治学', 'C', 1, b'1', b'0', NULL, '2022-07-11 18:33:53', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1547152618760048640, 1547152572798865408, 2, '入门', 'A', 1, b'1', b'0', NULL, '2022-07-13 17:35:04', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1547152643607105536, 1547152572798865408, 1, '初级', 'B', 1, b'1', b'0', NULL, '2022-07-13 17:35:10', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1547152666575114241, 1547152572798865408, 1, '中级', 'C', 1, b'1', b'0', NULL, '2022-07-13 17:35:15', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1547152686498058240, 1547152572798865408, 1, '高级', 'D', 1, b'1', b'0', NULL, '2022-07-13 17:35:20', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1560170162378903553, 1560150957805932546, 1, '开会', 'A', 1, b'1', b'0', NULL, '2022-08-18 15:42:08', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1560170208142954497, 1560150957805932546, 1, '出差', 'B', 1, b'1', b'0', NULL, '2022-08-18 15:42:19', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1560170378628829184, 1560151009815302144, 1, '一般', '#909399', 1, b'1', b'0', NULL, '2022-08-18 15:42:59', 'Admin', '2022-08-18 15:44:29', 'Admin', 0);
INSERT INTO `sys_code` VALUES (1560170655905878017, 1560151009815302144, 1, '中等', '#E6A23C', 1, b'1', b'0', NULL, '2022-08-18 15:44:06', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1560170714076680193, 1560151009815302144, 1, '紧急', '#F56C6C', 1, b'1', b'0', NULL, '2022-08-18 15:44:19', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1575679244049190912, 1575679160779673600, 1, '党群人力分会', '1', 1, b'1', b'0', NULL, '2022-09-30 10:49:41', 'Admin', '2022-09-30 10:50:03', 'Admin', 0);
INSERT INTO `sys_code` VALUES (1575679274944434177, 1575679160779673600, 1, '投资规划分会', '2', 1, b'1', b'0', NULL, '2022-09-30 10:49:49', 'Admin', '2022-09-30 10:50:09', 'Admin', 0);
INSERT INTO `sys_code` VALUES (1575679390296182785, 1575679160779673600, 1, '管理分会', '3', 1, b'1', b'0', NULL, '2022-09-30 10:50:16', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1575679418326716416, 1575679160779673600, 1, '采购分会', '4', 1, b'1', b'0', NULL, '2022-09-30 10:50:23', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1575679451679821824, 1575679160779673600, 1, '质量分会', '5', 1, b'1', b'0', NULL, '2022-09-30 10:50:31', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1575679478552727553, 1575679160779673600, 1, '生成制造分会', '6', 1, b'1', b'0', NULL, '2022-09-30 10:50:37', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1575679505136226304, 1575679160779673600, 1, '法务商品分会', '7', 1, b'1', b'0', NULL, '2022-09-30 10:50:43', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1575679531644227584, 1575679160779673600, 1, '财经分会', '8', 1, b'1', b'0', NULL, '2022-09-30 10:50:50', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589814751553261568, 1589811762029531138, 3, '互联网', 'A', 1, b'1', b'0', NULL, '2022-11-08 10:59:09', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589814777079795713, 1589811762029531138, 3, '金融', 'B', 1, b'1', b'0', NULL, '2022-11-08 10:59:15', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589814800249131009, 1589811762029531138, 3, '医疗', 'C', 1, b'1', b'0', NULL, '2022-11-08 10:59:20', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589814859149742081, 1589811679850532866, 3, '普通客户', 'A', 1, b'1', b'0', NULL, '2022-11-08 10:59:34', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589814891039035393, 1589811679850532866, 3, '重要客户', 'B', 1, b'1', b'0', NULL, '2022-11-08 10:59:42', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589814912824250369, 1589811679850532866, 3, '金牌客户', 'C', 1, b'1', b'0', NULL, '2022-11-08 10:59:47', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589815017841233921, 1589811626519957506, 3, '线上', 'A', 1, b'1', b'0', NULL, '2022-11-08 11:00:12', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589815147243900929, 1589811626519957506, 3, '人脉关系', 'B', 1, b'1', b'0', NULL, '2022-11-08 11:00:43', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1589815256375496705, 1589811626519957506, 3, '线下', 'C', 1, b'1', b'0', NULL, '2022-11-08 11:01:09', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590678616457482241, 1590639619156873216, 3, '热线电话', 'A', 1, b'1', b'0', NULL, '2022-11-10 20:11:50', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590678657125453825, 1590639619156873216, 3, '工作部署', 'B', 1, b'1', b'0', NULL, '2022-11-10 20:12:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590678692546351105, 1590639619156873216, 3, '其他途径', 'C', 1, b'1', b'0', NULL, '2022-11-10 20:12:08', '李四', '2022-11-10 20:12:13', '李四', 0);
INSERT INTO `sys_code` VALUES (1590678799924727808, 1590639691546365954, 3, '现场检查', 'A', 1, b'1', b'0', NULL, '2022-11-10 20:12:34', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590678831159709697, 1590639691546365954, 3, '现场验收', 'B', 1, b'1', b'0', NULL, '2022-11-10 20:12:41', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590678861950095361, 1590639691546365954, 3, '运维实施', 'C', 1, b'1', b'0', NULL, '2022-11-10 20:12:49', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590678894325927937, 1590639691546365954, 3, '故障处理', 'D', 1, b'1', b'0', NULL, '2022-11-10 20:12:56', '李四', '2022-11-10 20:13:12', '李四', 0);
INSERT INTO `sys_code` VALUES (1590678928362704897, 1590639691546365954, 3, '其他', 'E', 1, b'1', b'0', NULL, '2022-11-10 20:13:05', '李四', '2022-11-10 20:13:16', '李四', 0);
INSERT INTO `sys_code` VALUES (1590679029592231937, 1590641489350889472, 3, '紧急', 'A', 1, b'1', b'0', NULL, '2022-11-10 20:13:29', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590679062450409473, 1590641489350889472, 3, '优先', 'B', 1, b'1', b'0', NULL, '2022-11-10 20:13:37', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590679093270155265, 1590641489350889472, 3, '正常', 'C', 1, b'1', b'0', NULL, '2022-11-10 20:13:44', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1590679130842730496, 1590641489350889472, 3, '其他', 'D', 1, b'1', b'0', NULL, '2022-11-10 20:13:53', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594879551878598656, 1590679605969293312, 3, '非常满意', 'A', 1, b'1', b'0', NULL, '2022-11-22 10:24:51', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594879579124797440, 1590679605969293312, 3, '满意', 'B', 1, b'1', b'0', NULL, '2022-11-22 10:24:58', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594879617297158144, 1590679605969293312, 3, '一般', 'C', 1, b'1', b'0', NULL, '2022-11-22 10:25:07', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594879650138558464, 1590679605969293312, 3, '差', 'D', 1, b'1', b'0', NULL, '2022-11-22 10:25:15', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594879681264488448, 1590679605969293312, 3, '非常差', 'E', 1, b'1', b'0', NULL, '2022-11-22 10:25:22', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880012543201280, 1590679416386752514, 3, '高', 'A', 1, b'1', b'0', NULL, '2022-11-22 10:26:41', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880044893868032, 1590679416386752514, 3, '中', 'B', 1, b'1', b'0', NULL, '2022-11-22 10:26:49', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880074337882112, 1590679416386752514, 3, '低', 'C', 1, b'1', b'0', NULL, '2022-11-22 10:26:56', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880105669332992, 1590679526214602754, 3, '很好', 'A', 1, b'1', b'0', NULL, '2022-11-22 10:27:03', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880139425091584, 1590679526214602754, 3, '一般', 'B', 1, b'1', b'0', NULL, '2022-11-22 10:27:11', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880163135492096, 1590679526214602754, 3, '差', 'C', 1, b'1', b'0', NULL, '2022-11-22 10:27:17', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880287148478464, 1590679338309783554, 3, '认真负责', 'A', 1, b'1', b'0', NULL, '2022-11-22 10:27:47', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880346170724352, 1590679338309783554, 3, '积极主动', 'B', 1, b'1', b'0', NULL, '2022-11-22 10:28:01', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880392446480384, 1590679338309783554, 3, '热情耐心', 'C', 1, b'1', b'0', NULL, '2022-11-22 10:28:12', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880435610062848, 1590679338309783554, 3, '细致周到', 'D', 1, b'1', b'0', NULL, '2022-11-22 10:28:22', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1594880484553396224, 1590679338309783554, 3, '文明礼貌', 'E', 1, b'1', b'0', NULL, '2022-11-22 10:28:34', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692151658909696, 1595686972393918466, 4, '身份证', 'A', 1, b'1', b'0', NULL, '2022-11-24 16:13:50', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692178775085056, 1595686972393918466, 4, '护照', 'B', 1, b'1', b'0', NULL, '2022-11-24 16:13:57', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692227114438656, 1595686972393918466, 4, '其他', 'C', 1, b'1', b'0', NULL, '2022-11-24 16:14:08', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692442672304128, 1595691980208345088, 4, '在职', 'A', 1, b'1', b'0', NULL, '2022-11-24 16:15:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692477090762752, 1595691980208345088, 4, '外包', 'B', 1, b'1', b'0', NULL, '2022-11-24 16:15:08', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692554685386752, 1595691980208345088, 4, '实习', 'C', 1, b'1', b'0', NULL, '2022-11-24 16:15:26', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692608884183040, 1595691980208345088, 4, '顾问', 'D', 1, b'1', b'0', NULL, '2022-11-24 16:15:39', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692675808497664, 1595691980208345088, 4, '兼职', 'E', 1, b'1', b'0', NULL, '2022-11-24 16:15:55', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692740056846336, 1595691980208345088, 4, '试用', 'F', 1, b'1', b'0', NULL, '2022-11-24 16:16:10', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595692789939703808, 1595691980208345088, 4, '离职', 'G', 1, b'1', b'0', NULL, '2022-11-24 16:16:22', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595694037606731776, 1595693857713033216, 4, 'BOSS直聘', 'A', 1, b'1', b'0', NULL, '2022-11-24 16:21:20', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595694083093958656, 1595693857713033216, 4, '智联招聘', 'B', 1, b'1', b'0', NULL, '2022-11-24 16:21:31', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595694107395756032, 1595693857713033216, 4, '前程无忧', 'C', 1, b'1', b'0', NULL, '2022-11-24 16:21:36', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595694178040418304, 1595693857713033216, 4, '内推', 'D', 1, b'1', b'0', NULL, '2022-11-24 16:21:53', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595968694201225216, 1595691980208345088, 4, '劳务', 'F', 1, b'1', b'0', NULL, '2022-11-25 10:32:43', '李四', NULL, NULL, 0);
INSERT INTO `sys_code` VALUES (1595968819120181248, 1595691980208345088, 4, '返聘', 'H', 1, b'1', b'0', NULL, '2022-11-25 10:33:13', '李四', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_codetype
-- ----------------------------
DROP TABLE IF EXISTS `sys_codetype`;
CREATE TABLE `sys_codetype` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `ParentId` bigint NOT NULL COMMENT '父节点',
  `ParentIdList` varchar(500) DEFAULT NULL,
  `Layer` int NOT NULL DEFAULT '1' COMMENT '层级',
  `Name` varchar(30) DEFAULT NULL COMMENT '分类名称',
  `Code` varchar(50) DEFAULT NULL COMMENT '标识',
  `Types` int NOT NULL DEFAULT '1' COMMENT '1=系统 2=商城',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `IsSystem` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否系统内置集成',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='字典分类信息';

-- ----------------------------
-- Records of sys_codetype
-- ----------------------------
BEGIN;
INSERT INTO `sys_codetype` VALUES (1540271598412632064, 0, '[\"0\"]', 1, '年级', 'grand', 2, 14, b'0', b'0', '2022-06-24 17:52:21', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1540271653957799938, 0, '[\"0\"]', 1, '学科', 'subject', 2, 15, b'0', b'0', '2022-06-24 17:52:34', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1542418195795808256, 0, '[\"0\"]', 1, '试卷类型', 'paperType', 2, 16, b'0', b'0', '2022-06-30 16:02:09', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1546442332772110336, 0, '[\"0\"]', 1, '教师专业', 'profession', 2, 17, b'0', b'0', '2022-07-11 18:32:38', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1547152572798865408, 0, '[\"0\"]', 1, '课程难度', 'difficulty', 2, 18, b'0', b'0', '2022-07-13 17:34:53', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1560150843783778304, 0, '[\"0\"]', 1, '日程', 'calendar', 1, 19, b'0', b'0', '2022-08-18 14:25:22', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1560150957805932546, 1560150843783778304, '[\"1560150843783778304\",\"0\"]', 2, '日程分类', 'calendar-type', 1, 20, b'0', b'0', '2022-08-18 14:25:49', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1560151009815302144, 1560150843783778304, '[\"1560150843783778304\",\"0\"]', 2, '日程级别', 'calendar-level', 1, 21, b'0', b'0', '2022-08-18 14:26:02', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1575679105234505728, 0, '[\"0\"]', 1, '活动', 'activity', 1, 22, b'0', b'0', '2022-09-30 10:49:08', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1575679160779673600, 1575679105234505728, '[\"1575679105234505728\",\"0\"]', 2, '所在分会', 'will', 1, 23, b'0', b'0', '2022-09-30 10:49:21', 'Admin', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1589809404746797056, 0, '[\"0\"]', 1, '客户配置', 'customer', 3, 24, b'0', b'0', '2022-11-08 10:37:54', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1589811626519957506, 1589809404746797056, '[\"1589809404746797056\",\"0\"]', 2, '来源', 'source', 3, 25, b'0', b'0', '2022-11-08 10:46:44', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1589811679850532866, 1589809404746797056, '[\"1589809404746797056\",\"0\"]', 2, '级别', 'level', 3, 26, b'0', b'0', '2022-11-08 10:46:56', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1589811762029531138, 1589809404746797056, '[\"1589809404746797056\",\"0\"]', 2, '行业', 'industry', 3, 27, b'0', b'0', '2022-11-08 10:47:16', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1590639334334271488, 0, '[\"0\"]', 1, '工单配置', 'woc', 3, 28, b'0', b'0', '2022-11-10 17:35:45', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1590639619156873216, 1590639334334271488, '[\"1590639334334271488\",\"1590639619156873216\"]', 2, '来源', 'woc-source', 3, 29, b'0', b'0', '2022-11-10 17:36:53', '李四', '2022-11-10 17:43:47', '李四', 0);
INSERT INTO `sys_codetype` VALUES (1590639691546365954, 1590639334334271488, '[\"1590639334334271488\",\"1590639691546365954\"]', 2, '类型', 'woc-type', 3, 30, b'0', b'0', '2022-11-10 17:37:10', '李四', '2022-11-10 17:40:48', '李四', 0);
INSERT INTO `sys_codetype` VALUES (1590641489350889472, 1590639334334271488, '[\"1590639334334271488\",\"0\"]', 2, '级别', 'woc-level', 3, 31, b'0', b'0', '2022-11-10 17:44:18', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1590679248337768448, 0, '[]', 1, '回访配置', 'visit', 3, 32, b'0', b'0', '2022-11-10 20:14:21', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1590679338309783554, 1590679248337768448, '[]', 1, '服务态度', 'service', 3, 33, b'0', b'0', '2022-11-10 20:14:42', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1590679416386752514, 1590679248337768448, '[]', 1, '工作效率', 'efficiency', 3, 34, b'0', b'0', '2022-11-10 20:15:01', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1590679526214602754, 1590679248337768448, '[]', 1, '业务水平', 'business', 3, 35, b'0', b'0', '2022-11-10 20:15:27', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1590679605969293312, 1590679248337768448, '[]', 1, '满意度', 'satisfact', 3, 36, b'0', b'0', '2022-11-10 20:15:46', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1595686828160192512, 0, '[]', 1, '员工配置', 'employee', 4, 37, b'0', b'0', '2022-11-24 15:52:41', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1595686972393918466, 1595686828160192512, '[]', 1, '证件类型', 'employee-certificate', 4, 38, b'0', b'0', '2022-11-24 15:53:15', '李四', NULL, NULL, 0);
INSERT INTO `sys_codetype` VALUES (1595691980208345088, 1595686828160192512, '[]', 1, '员工状态', 'employee-status', 4, 39, b'0', b'0', '2022-11-24 16:13:09', '李四', '2022-11-24 16:13:24', '李四', 0);
INSERT INTO `sys_codetype` VALUES (1595693857713033216, 1595686828160192512, '[]', 1, '招聘渠道', 'employee-job', 4, 40, b'0', b'0', '2022-11-24 16:20:37', '李四', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_file_column
-- ----------------------------
DROP TABLE IF EXISTS `sys_file_column`;
CREATE TABLE `sys_file_column` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `ParentId` bigint NOT NULL DEFAULT '0' COMMENT '父编号',
  `ParentIdList` varchar(128) NOT NULL COMMENT '父编号集合',
  `Type` int NOT NULL DEFAULT '0' COMMENT '类型 图片类型分类 0=本地 1=云端',
  `Layer` int NOT NULL DEFAULT '1' COMMENT '级别',
  `Sort` int DEFAULT NULL COMMENT '排序',
  `Name` varchar(50) NOT NULL COMMENT '栏目名称',
  `EnName` varchar(128) NOT NULL COMMENT '英文名称 文件夹名称',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='资源栏目表 ';

-- ----------------------------
-- Table structure for sys_file_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_file_info`;
CREATE TABLE `sys_file_info` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `ColumnId` bigint NOT NULL DEFAULT '0' COMMENT '所属栏目',
  `Name` varchar(100) NOT NULL COMMENT '文件名称',
  `FileUrl` varchar(128) DEFAULT NULL COMMENT '文件地址',
  `FileType` varchar(32) NOT NULL COMMENT '文件类型',
  `FileSize` bigint NOT NULL COMMENT '文件大小',
  `ImgSmall` varchar(128) DEFAULT NULL COMMENT '图片缩略图',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `IsDel` bit(1) DEFAULT NULL COMMENT '是否删除',
  `CreateTime` datetime DEFAULT NULL COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='资源文件信息表 ';

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `Id` bigint NOT NULL,
  `Level` varchar(20) DEFAULT NULL COMMENT '级别',
  `LogType` int NOT NULL COMMENT '日志类型  1=登录  2=操作',
  `Module` varchar(100) DEFAULT NULL COMMENT '操作模块',
  `OperateType` varchar(20) DEFAULT NULL COMMENT '操作类型:例如添加、修改',
  `Method` varchar(10) DEFAULT NULL COMMENT '提交类型：get/post/delete',
  `OperateUser` varchar(30) DEFAULT NULL COMMENT '操作人',
  `IP` varchar(50) DEFAULT NULL COMMENT 'IP',
  `Parameters` longtext COMMENT '请求参数',
  `Address` varchar(500) DEFAULT NULL COMMENT '操作地址',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '操作状态',
  `Message` varchar(2000) DEFAULT NULL COMMENT '详细信息',
  `ReturnValue` longtext COMMENT '返回结果',
  `OperateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
  `Browser` varchar(1000) DEFAULT NULL COMMENT '浏览器信息',
  `ExecutionDuration` int NOT NULL DEFAULT '0' COMMENT '执行时长',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='登录日志\r\n操作日志\r\n任务日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (1622492122232000513, '2', 2, 'FytSoa.Application.Operator.WorkbenchService', NULL, 'GET', '李四', '::ffff:223.75.228.160', '', '/api/workbench/resourceuse?_=1675667412961', b'1', NULL, '{\"TotalMemory\":\"3931.3\",\"MemoryRate\":10.39,\"CpuRate\":0,\"DiskRate\":36,\"RunTime\":\"00 u5929 00 u5C0Fu65F6 06 u5206 22 u79D2\",\"NetWorkUp\":11242303,\"NetWorkDown\":11242288}', '2023-02-06 15:07:21', 'Chrome', 161, 0);
INSERT INTO `sys_log` VALUES (1622492122244583425, '2', 2, 'FytSoa.Application.Operator.WorkbenchService', NULL, 'GET', '李四', '::ffff:223.75.228.160', '', '/api/workbench/resourceuse?_=1675667412959', b'1', NULL, '{\"TotalMemory\":\"3931.3\",\"MemoryRate\":10.39,\"CpuRate\":0,\"DiskRate\":36,\"RunTime\":\"00 u5929 00 u5C0Fu65F6 06 u5206 22 u79D2\",\"NetWorkUp\":11242310,\"NetWorkDown\":11242295}', '2023-02-06 15:07:21', 'Chrome', 164, 0);
INSERT INTO `sys_log` VALUES (1622492123410599937, '2', 2, 'FytSoa.Application.Operator.WorkbenchService', NULL, 'GET', '李四', '::ffff:223.75.228.160', '', '/api/workbench/resourceuse?_=1675667412960', b'1', NULL, '{\"TotalMemory\":\"3931.3\",\"MemoryRate\":10.41,\"CpuRate\":3.2,\"DiskRate\":36,\"RunTime\":\"00 u5929 00 u5C0Fu65F6 06 u5206 23 u79D2\",\"NetWorkUp\":11242324,\"NetWorkDown\":11242309}', '2023-02-06 15:07:21', 'Chrome', 161, 0);
INSERT INTO `sys_log` VALUES (1622492123473514497, '2', 2, 'FytSoa.Application.Operator.WorkbenchService', NULL, 'GET', '李四', '::ffff:223.75.228.160', '', '/api/workbench/resourceuse?_=1675667412962', b'1', NULL, '{\"TotalMemory\":\"3931.3\",\"MemoryRate\":10.41,\"CpuRate\":3.1,\"DiskRate\":36,\"RunTime\":\"00 u5929 00 u5C0Fu65F6 06 u5206 23 u79D2\",\"NetWorkUp\":11242331,\"NetWorkDown\":11242316}', '2023-02-06 15:07:21', 'Chrome', 161, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `Name` varchar(30) NOT NULL COMMENT '菜单名称',
  `ParentId` bigint DEFAULT NULL COMMENT '父节点',
  `ParentIdList` varchar(200) DEFAULT NULL COMMENT '父节点集合组',
  `Code` varchar(30) DEFAULT NULL COMMENT '权限标识',
  `Layer` int NOT NULL DEFAULT '1' COMMENT '菜单层级',
  `Urls` varchar(100) DEFAULT NULL COMMENT '路由地址',
  `Redirect` varchar(100) DEFAULT NULL COMMENT '重定向',
  `VuePath` varchar(100) DEFAULT NULL COMMENT 'Vue文件路径',
  `Icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `Active` varchar(200) DEFAULT NULL COMMENT '菜单高亮',
  `Color` varchar(20) DEFAULT NULL COMMENT '颜色',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `Fullpage` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否全屏',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `Types` varchar(20) NOT NULL DEFAULT '1' COMMENT '菜单类型',
  `Api` varchar(2000) DEFAULT NULL COMMENT '接口权限',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='资源菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1505743735667953665, '主页', 0, '[\"1505743735667953665\"]', 'home', 1, '/home', NULL, NULL, 'el-icon-house', NULL, NULL, 2, b'0', b'1', b'0', 'menu', '[]', '2022-03-21 11:10:57', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1505749765281943553, '工作台', 1505743735667953665, '[\"1505743735667953665\",\"1505749765281943553\"]', 'dashboard', 1, '/dashboard', NULL, 'home', 'el-icon-menu', NULL, NULL, 3, b'0', b'1', b'0', 'menu', '[]', '2022-03-21 11:34:54', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1505750037081231361, '个人信息', 1505743735667953665, '[\"1505743735667953665\",\"1505750037081231361\"]', 'userCenter', 1, '/usercenter', NULL, 'userCenter', 'el-icon-user', NULL, NULL, 4, b'0', b'1', b'0', 'menu', '[{\"code\":\"查看\",\"method\":\"GET\",\"url\":\"/api/sysadmin/basic\"},{\"code\":\"编辑\",\"method\":\"POST\",\"url\":\"/api/sysadmin/basic\"}]', '2022-03-21 11:35:59', NULL, '2022-05-20 18:46:08', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505750499046068225, '组件中心', 1590623130446073856, '[\"1505750741799800833\"]', 'modules', 1, '/modules', NULL, NULL, 'el-icon-takeaway-box', NULL, NULL, 6, b'0', b'1', b'0', 'menu', '[]', '2022-03-21 11:37:49', NULL, '2022-08-31 14:28:16', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505750741799800833, '代码生成器', 1505750499046068225, '[\"1505750499046068225\",\"1505751087574028289\"]', 'generate', 1, '/modules/generate', NULL, 'modules/generate', 'sc-icon-code', NULL, NULL, 2, b'0', b'1', b'0', 'menu', '[{\"code\":\"查看\",\"method\":\"POST\",\"url\":\"/api/generator\"},{\"code\":\"生成\",\"method\":\"POST\",\"url\":\"/api/generator\"}]', '2022-03-21 11:38:47', NULL, '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505751087574028289, '资源库管理', 1505750499046068225, '[\"1505750499046068225\",\"1519880746058256384\"]', 'sysfile', 1, '/sys/file', NULL, 'sys/file', 'el-icon-folder-checked', NULL, NULL, 3, b'0', b'1', b'0', 'menu', '[{\"code\":\"上传\",\"method\":\"POST\",\"url\":\"/api/sysfile/upload\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysfile/file\"}]', '2022-03-21 11:40:09', NULL, '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505751488931172353, '消息管理', 1505750499046068225, '[\"1505750499046068225\",\"1505751488931172353\"]', 'sysmessage', 1, '/sys/message', NULL, 'sys/message', 'el-icon-bell', NULL, NULL, 9, b'0', b'1', b'0', 'menu', '[{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysmessage\"},{\"code\":\"已读\",\"method\":\"PUT\",\"url\":\"/api/sysmessage/read\"},{\"code\":\"回收站\",\"method\":\"DELETE\",\"url\":\"/api/sysmessage/recycle\"}]', '2022-03-21 11:41:45', NULL, '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505751622146461697, '任务调度', 1505750499046068225, '[\"1505750499046068225\",\"1505751622146461697\"]', 'modulestask', 1, '/modules/task', NULL, 'modules/task', 'el-icon-alarm-clock', NULL, NULL, 5, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysquartz\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysquartz\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysquartz\"},{\"code\":\"暂停\",\"method\":\"PUT\",\"url\":\"/api/sysquartz/pausejob\"},{\"code\":\"开启\",\"method\":\"PUT\",\"url\":\"/api/sysquartz/startjob\"},{\"code\":\"执行\",\"method\":\"PUT\",\"url\":\"/api/sysquartz/runjob\"}]', '2022-03-21 11:42:17', NULL, '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505751857547579393, '配置中心', 1590623130446073856, '[\"1505751857547579393\"]', 'setting', 1, '/setting', NULL, NULL, 'el-icon-setting', NULL, NULL, 10, b'0', b'1', b'0', 'menu', '[]', '2022-03-21 11:43:13', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1505752082601349121, '数据字典', 1505751857547579393, '[\"1505751857547579393\",\"1505752082601349121\"]', 'syscode', 1, '/sys/code', NULL, 'sys/code', 'el-icon-document-copy', NULL, NULL, 11, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加栏目\",\"method\":\"POST\",\"url\":\"/api/syscodetype\"},{\"code\":\"编辑栏目\",\"method\":\"PUT\",\"url\":\"/api/syscodetype\"},{\"code\":\"删除栏目\",\"method\":\"DELETE\",\"url\":\"/api/syscodetype\"},{\"code\":\"添加字典\",\"method\":\"POST\",\"url\":\"/api/syscode\"},{\"code\":\"编辑字典\",\"method\":\"PUT\",\"url\":\"/api/syscode\"},{\"code\":\"删除字典\",\"method\":\"DELETE\",\"url\":\"/api/syscode\"}]', '2022-03-21 11:44:07', NULL, '2022-05-20 17:38:42', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505752395358015489, '城市区域', 1505751857547579393, '[\"1505751857547579393\",\"1505752395358015489\"]', 'syscity', 1, '/sys/city', NULL, 'sys/city', 'el-icon-aim', NULL, NULL, 12, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/syscity\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/syscity\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/syscity\"},{\"code\":\"排序\",\"method\":\"POST\",\"url\":\"/api/syscity/colsort\"}]', '2022-03-21 11:45:21', NULL, '2022-05-20 17:40:03', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505752728201203713, '安全设置', 1505751857547579393, '[\"1505751857547579393\",\"1505752728201203713\"]', 'syssafety', 1, '/sys/safety', NULL, 'sys/safety', 'el-icon-key', NULL, NULL, 13, b'0', b'1', b'0', 'menu', '[{\"code\":\"保存\",\"method\":\"POST\",\"url\":\"/api/syssafety\"}]', '2022-03-21 11:46:41', NULL, '2022-05-20 17:44:21', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505752932937764865, '组织成员', 1590623130446073856, '[\"1505752932937764865\"]', 'sys', 1, '/sys', NULL, NULL, 'el-icon-sunset', NULL, NULL, 14, b'0', b'1', b'0', 'menu', '[]', '2022-03-21 11:47:29', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1505753200123318273, '机构管理', 1505752932937764865, '[\"1505752932937764865\",\"1505753200123318273\"]', 'sysorganize', 1, '/sys/organize', NULL, 'sys/organize', 'el-icon-place', NULL, NULL, 15, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysorganize\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysorganize\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysorganize\"},{\"code\":\"排序\",\"method\":\"POST\",\"url\":\"/api/sysorganize/colsort\"}]', '2022-03-21 11:48:33', NULL, '2022-05-20 17:45:30', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505753465199136769, '角色管理', 1505752932937764865, '[\"1505752932937764865\",\"1505753465199136769\"]', 'sysrole', 1, '/sys/role', NULL, 'sys/role', 'el-icon-notebook', NULL, NULL, 16, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysrole\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysrole\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysrole\"}]', '2022-03-21 11:49:36', NULL, '2022-05-20 17:46:17', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505753657151459329, '职位管理', 1505752932937764865, '[\"1505752932937764865\",\"1505753657151459329\"]', 'syspost', 1, '/sys/post', NULL, 'sys/post', 'el-icon-monitor', NULL, NULL, 17, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/syspost\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/syspost\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/syspost\"}]', '2022-03-21 11:50:22', NULL, '2022-05-20 17:46:53', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505753850097831937, '用户管理', 1505752932937764865, '[\"1505752932937764865\",\"1505753850097831937\"]', 'sysadmin', 1, '/sys/admin', NULL, 'sys/admin', 'el-icon-user', NULL, NULL, 18, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysadmin\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysadmin\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysadmin\"},{\"code\":\"密码重置\",\"method\":\"PUT\",\"url\":\"/api/sysadmin/passreset\"}]', '2022-03-21 11:51:08', NULL, '2022-05-20 17:48:12', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505753983766106113, '资源管理', 1505752932937764865, '[\"1505752932937764865\",\"1505753983766106113\"]', 'sysmenu', 1, '/sys/menu', NULL, 'sys/menu', 'el-icon-expand', NULL, NULL, 19, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysmenu/temp\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysmenu\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysmenu\"},{\"code\":\"排序\",\"method\":\"POST\",\"url\":\"/api/sysmenu/colsort\"}]', '2022-03-21 11:51:40', NULL, '2022-05-20 17:49:46', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505754140607909889, '权限管理', 1505752932937764865, '[\"1505752932937764865\",\"1505754140607909889\"]', 'syspermission-manager', 1, '/sys/permission-manager', NULL, 'sys/permission', 'el-icon-finished', NULL, NULL, 20, b'0', b'1', b'0', 'menu', '[{\"code\":\"保存\",\"method\":\"POST\",\"url\":\"/api/sysauthority\"}]', '2022-03-21 11:52:17', NULL, '2023-02-06 15:04:58', '李四', 0);
INSERT INTO `sys_menu` VALUES (1505754323739611137, '系统日志', 1505752932937764865, '[\"1505752932937764865\",\"1505754323739611137\"]', 'syslog', 1, '/sys/log', NULL, 'sys/log', 'el-icon-document-copy', NULL, NULL, 21, b'0', b'1', b'0', 'menu', '[{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/syslog\"},{\"code\":\"清空\",\"method\":\"DELETE\",\"url\":\"/api/syslog/clear\"}]', '2022-03-21 11:53:01', NULL, '2022-05-20 17:54:27', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1505764157008515073, '广告管理', 1505750499046068225, '[\"1505750499046068225\",\"1505764157008515073\"]', 'modulesadv', 1, '/modules/adv', NULL, 'modules/adv', 'el-icon-files', NULL, NULL, 4, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加栏目\",\"method\":\"POST\",\"url\":\"/api/sysadvcolumn\"},{\"code\":\"编辑栏目\",\"method\":\"PUT\",\"url\":\"/api/sysadvcolumn\"},{\"code\":\"删除栏目\",\"method\":\"DELETE\",\"url\":\"/api/sysadvcolumn\"},{\"code\":\"添加广告\",\"method\":\"POST\",\"url\":\"/api/sysadvInfo\"},{\"code\":\"编辑广告\",\"method\":\"PUT\",\"url\":\"/api/sysadvInfo\"},{\"code\":\"删除广告\",\"method\":\"DELETE\",\"url\":\"/api/sysadvInfo\"}]', '2022-03-21 12:32:05', NULL, '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506093853084618753, '内容', 1590627984631533568, '[\"1506093853084618753\"]', 'cms', 1, '/cms', NULL, NULL, 'el-icon-set-up', NULL, NULL, 23, b'0', b'1', b'0', 'menu', '[]', '2022-03-22 10:22:11', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1506094265032380417, '栏目管理', 1506093853084618753, '[\"1506093853084618753\",\"1506094265032380417\"]', 'cmscolumn', 1, '/cms/column', NULL, 'cms/column', 'el-icon-expand', NULL, NULL, 24, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/cmscolumn\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/cmscolumn\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/cmscolumn\"},{\"code\":\"排序\",\"method\":\"POST\",\"url\":\"/api/cmscolumn/colsort\"}]', '2022-03-22 10:23:49', NULL, '2022-05-20 17:56:08', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506094494225928193, '文章管理', 1506093853084618753, '[\"1506093853084618753\",\"1506094494225928193\"]', 'cmsarticle', 1, '/cms/article', NULL, 'cms/article', 'el-icon-tickets', NULL, NULL, 25, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/cmsarticle\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/cmsarticle\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/cmsarticle\"},{\"code\":\"回收站删除\",\"method\":\"PUT\",\"url\":\"/api/cmsarticle/recycle\"},{\"code\":\"回收站恢复\",\"method\":\"PUT\",\"url\":\"/api/cmsarticle/recovery\"}]', '2022-03-22 10:24:44', NULL, '2022-05-20 17:58:13', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506094671250722817, '模板管理', 1506093853084618753, '[\"1506093853084618753\",\"1506094671250722817\"]', 'cmstemplate', 1, '/cms/template', NULL, 'cms/template', 'el-icon-collection', NULL, NULL, 26, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/cmstemplate\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/cmstemplate\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/cmstemplate\"}]', '2022-03-22 10:25:26', NULL, '2022-05-20 17:58:50', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506187567358414849, '会员', 1590627984631533568, '[\"1506187567358414849\"]', 'user', 1, '/user', NULL, NULL, 'el-icon-user', NULL, NULL, 27, b'0', b'1', b'0', 'menu', '[]', '2022-03-22 16:34:34', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1506188179915542529, '会员组', 1506187567358414849, '[\"1506187567358414849\",\"1506188179915542529\"]', 'usergroup', 1, '/user/group', NULL, 'user/group', 'el-icon-files', NULL, NULL, 28, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/membergroup\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/membergroup\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/membergroup\"}]', '2022-03-22 16:37:00', NULL, '2022-05-20 18:00:02', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506188430009307137, '会员信息', 1506187567358414849, '[\"1506187567358414849\",\"1506188430009307137\"]', 'userlist', 1, '/user/list', NULL, 'user/list', 'el-icon-avatar', NULL, NULL, 29, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/member\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/member\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/member\"}]', '2022-03-22 16:38:00', NULL, '2022-05-20 18:00:43', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506524557157208065, '汽车', 1590627984631533568, '[\"1506524557157208065\"]', 'cars', 1, '/cars', NULL, NULL, 'el-icon-van', NULL, NULL, 30, b'0', b'1', b'0', 'menu', '[]', '2022-03-23 14:53:39', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1506524879816626177, '预约试驾', 1506524557157208065, '[\"1506524557157208065\",\"1506524879816626177\"]', 'carsreserve', 1, '/cars/reserve', NULL, 'cars/reserve', 'el-icon-tickets', NULL, NULL, 31, b'0', b'1', b'0', 'menu', '[{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/carsreserve\"},{\"code\":\"状态\",\"method\":\"PUT\",\"url\":\"/api/carsreserve/status\"}]', '2022-03-23 14:54:56', NULL, '2022-05-20 18:02:23', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506559646230515713, '抽奖管理', 1506524557157208065, '[\"1506524557157208065\",\"1506559646230515713\"]', 'carsprize', 1, '/cars/prize', NULL, 'cars/prize', 'el-icon-aim', NULL, NULL, 35, b'0', b'1', b'0', 'menu', '[]', '2022-03-23 17:13:05', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1506560054290157569, '活动设置', 1506559646230515713, '[\"1506559646230515713\",\"1506560054290157569\"]', 'carsprizesetting', 1, '/cars/prize/setting', NULL, 'cars/prize', '', NULL, NULL, 36, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/carsprize\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/carsprize\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/carsprize\"}]', '2022-03-23 17:14:42', NULL, '2022-05-20 18:03:13', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506560247593046017, '抽奖记录', 1506559646230515713, '[\"1506559646230515713\",\"1506560247593046017\"]', 'carsprizelog', 1, '/cars/prize/log', NULL, 'cars/prize/log', '', NULL, NULL, 37, b'0', b'1', b'0', 'menu', '[{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/carsprizelog\"},{\"code\":\"已读\",\"method\":\"PUT\",\"url\":\"/api/carsprizelog/status\"}]', '2022-03-23 17:15:28', NULL, '2022-05-20 18:04:03', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506812417865289729, '积分商城', 1506524557157208065, '[\"1506524557157208065\",\"1506812417865289729\"]', 'shop-points', 1, '/shop/points', NULL, NULL, 'el-icon-shopping-cart-full', NULL, NULL, 38, b'0', b'1', b'0', 'menu', '[]', '2022-03-24 09:57:30', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (1506812669225734145, '商品管理', 1506812417865289729, '[\"1506812417865289729\",\"1506812669225734145\"]', 'shop-points-goods', 1, '/shop/points/goods', NULL, 'shop/points/goods', '', NULL, NULL, 39, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/shoppointsgoods\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/shoppointsgoods\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/shoppointsgoods\"}]', '2022-03-24 09:58:30', NULL, '2022-05-20 18:04:55', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1506812834963656705, '订单管理', 1506812417865289729, '[\"1506812417865289729\",\"1506812834963656705\"]', 'shoppointsgoods', 1, '/shop/points/order', NULL, 'shop/points/order', '', NULL, NULL, 40, b'0', b'1', b'0', 'menu', '[{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/shoppointsorder\"},{\"code\":\"确认\",\"method\":\"PUT\",\"url\":\"/api/shoppointsorder/status\"}]', '2022-03-24 09:59:10', NULL, '2022-05-20 18:05:47', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1514445260992942081, '游戏管理', 1506524557157208065, '[\"1506524557157208065\",\"1514445260992942081\"]', 'carsgame', 1, '/cars/game', NULL, 'cars/game', 'el-icon-orange', NULL, NULL, 41, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/carsgame\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/carsgame\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/carsgame\"}]', '2022-04-14 11:27:42', NULL, '2022-05-20 18:06:32', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1519508966684626944, '在线用户', 1505752932937764865, '[\"1505752932937764865\",\"1519508966684626944\"]', 'sysonline', 1, '/sys/online', NULL, 'sys/online', 'el-icon-discount', NULL, NULL, 42, b'0', b'1', b'0', 'menu', '[]', '2022-04-28 10:49:03', 'Admin', '2022-04-28 10:51:22', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1519880746058256384, '投票管理', 1505750499046068225, '[\"1505750499046068225\",\"1519880746058256384\"]', 'modulesvote', 1, '/modules/vote', NULL, 'modules/vote', 'el-icon-histogram', NULL, NULL, 7, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysvote\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysvote\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysvote\"}]', '2022-04-29 11:26:23', 'Admin', '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1527239267519172608, '站点管理', 1506093853084618753, '[\"1506093853084618753\",\"1527239267519172608\"]', 'cmssite', 1, '/cms/site', NULL, 'cms/site', 'el-icon-monitor', NULL, NULL, 44, b'0', b'1', b'0', 'menu', '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/cmssite\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/cmssite\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/cmssite\"}]', '2022-05-19 18:46:31', 'Admin', '2022-05-20 17:59:23', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1530078871695790080, '日程管理', 1505750499046068225, '[\"1505750499046068225\",\"1519880746058256384\"]', 'calendar', 1, '/sys/calendar', NULL, 'sys/calendar', 'el-icon-calendar', NULL, NULL, 6, b'0', b'1', b'0', 'menu', '[]', '2022-05-27 14:50:05', 'Admin', '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1539525292010377216, '课程', 1590627984631533568, '[\"1539525292010377216\"]', 'exam', 1, '/exam', NULL, NULL, 'el-icon-stopwatch', NULL, NULL, 47, b'0', b'1', b'0', 'menu', '[]', '2022-06-22 16:26:47', 'Admin', '2022-06-22 16:29:44', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1539526260865241089, '题库管理', 1539525292010377216, '[\"1539525292010377216\",\"1545245498565332993\"]', 'examquestion', 1, '/exam/question', NULL, 'exam/question', 'el-icon-document-copy', NULL, NULL, 56, b'0', b'1', b'0', 'menu', '[]', '2022-06-22 16:30:38', 'Admin', '2022-07-08 11:21:18', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1539528489735163905, '试卷管理', 1539525292010377216, '[\"1539525292010377216\",\"1545245498565332993\"]', 'exampaper', 1, '/exam/paper', NULL, 'exam/paper', 'el-icon-coin', NULL, NULL, 49, b'0', b'1', b'0', 'menu', '[]', '2022-06-22 16:39:30', 'Admin', '2022-07-08 11:21:27', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1539528825413701633, '考试管理', 1539525292010377216, '[\"1539525292010377216\",\"1539528825413701633\"]', 'examuserlog', 1, '/exam/userlog', NULL, 'exam/userlog', 'el-icon-collection', NULL, NULL, 50, b'0', b'1', b'0', 'menu', '[]', '2022-06-22 16:40:50', 'Admin', '2022-06-22 16:41:29', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1539529100392271873, '试卷列表', 1539528489735163905, '[\"1539528489735163905\",\"1539529100392271873\"]', 'exampaperlist', 1, '/exam/paper', NULL, 'exam/paper', '', NULL, NULL, 51, b'0', b'1', b'0', 'menu', '[]', '2022-06-22 16:41:55', 'Admin', '2022-06-22 16:42:44', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1539529362251059201, '智能组卷', 1539528489735163905, '[\"1539528489735163905\",\"1539529362251059201\"]', 'exampaperai', 1, '/exam/paper/smart', NULL, 'exam/paper/smart', '', NULL, NULL, 52, b'0', b'1', b'0', 'menu', '[]', '2022-06-22 16:42:58', 'Admin', '2022-07-04 16:49:45', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1540250135517335553, '基础配置', 1539525292010377216, '[\"1539525292010377216\",\"1540250135517335553\"]', 'exambasic', 1, '/exam/setting', NULL, 'sys/code', 'el-icon-setting', NULL, NULL, 48, b'0', b'1', b'0', 'menu', '[]', '2022-06-24 16:27:03', 'Admin', '2022-07-11 17:29:17', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1544215708278329344, '批改详情', 1539528825413701633, '[\"1539528825413701633\",\"1544215708278329344\"]', 'examcorrecting', 1, '/exam/userlog/detail', NULL, 'exam/userlog/detail', '', NULL, NULL, 54, b'0', b'0', b'0', 'menu', '[]', '2022-07-05 15:04:50', 'Admin', '2022-07-05 15:06:24', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1544224763176685568, '批改试卷', 1539528825413701633, '[\"1539528825413701633\",\"1544224763176685568\"]', 'examcorrect', 1, '/exam/userlog/correct', NULL, 'exam/userlog/correct', '', NULL, NULL, 55, b'1', b'0', b'0', 'menu', '[]', '2022-07-05 15:40:49', 'Admin', '2022-07-05 18:13:39', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1545245498565332993, '知识管理', 1539525292010377216, '[\"1539525292010377216\",\"1540250135517335553\"]', 'examknowledge', 1, '/exam/knowledge', NULL, NULL, 'el-icon-message-box', NULL, NULL, 53, b'0', b'1', b'0', 'menu', '[]', '2022-07-08 11:16:51', 'Admin', '2022-07-11 17:29:18', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1545245798642618369, '分类管理', 1545245498565332993, '[\"1545245498565332993\",\"1545245798642618369\"]', 'examknowledgecategory', 1, '/exam/knowledge/category', NULL, 'exam/knowledge/category', '', NULL, NULL, 57, b'0', b'1', b'0', 'menu', '[]', '2022-07-08 11:18:02', 'Admin', '2022-07-08 11:18:25', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1545246104927473664, '知识库管理', 1545245498565332993, '[\"1545245498565332993\",\"1545246104927473664\"]', 'examknowledgelist', 1, '/exam/knowledge/list', NULL, 'exam/knowledge', '', NULL, NULL, 58, b'0', b'1', b'0', 'menu', '[]', '2022-07-08 11:19:15', 'Admin', '2022-07-08 11:28:37', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1546423325385953280, '讲师管理', 1539525292010377216, '[\"1539525292010377216\",\"1546423325385953280\"]', 'examteacher', 1, '/exam/teacher', NULL, 'exam/teacher', 'el-icon-avatar', NULL, NULL, 59, b'0', b'1', b'0', 'menu', '[]', '2022-07-11 17:17:07', 'Admin', '2022-07-11 17:17:56', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1546423680886771713, '素材管理', 1539525292010377216, '[\"1539525292010377216\",\"1546423680886771713\"]', 'exammaterialmanager', 1, '/exam/materialmanager', NULL, '', 'el-icon-document-remove', NULL, NULL, 60, b'0', b'1', b'0', 'menu', '[]', '2022-07-11 17:18:31', 'Admin', '2022-07-11 17:21:35', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1546424056004349953, '素材分类', 1546423680886771713, '[\"1546423680886771713\",\"1546424056004349953\"]', 'exammaterialcategory', 1, '/exam/material/category', NULL, 'exam/material/category', '', NULL, NULL, 61, b'0', b'1', b'0', 'menu', '[]', '2022-07-11 17:20:01', 'Admin', '2022-07-11 17:20:35', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1546424207448084481, '素材管理', 1546423680886771713, '[\"1546423680886771713\",\"1546424207448084481\"]', 'exammaterial', 1, '/exam/material', NULL, 'exam/material', '', NULL, NULL, 62, b'0', b'1', b'0', 'menu', '[]', '2022-07-11 17:20:37', 'Admin', '2022-07-12 11:17:55', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1546424575766695937, '课程管理', 1539525292010377216, '[\"1539525292010377216\",\"1546424575766695937\"]', NULL, 1, 'examkc', NULL, NULL, 'el-icon-set-up', NULL, NULL, 63, b'0', b'1', b'0', 'menu', '[]', '2022-07-11 17:22:05', 'Admin', '2022-07-11 17:23:17', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1546425026297860097, '课程列表', 1546424575766695937, '[\"1546424575766695937\",\"1546425026297860097\"]', 'examcourse', 1, '/exam/course', NULL, 'exam/course', '', NULL, NULL, 64, b'0', b'1', b'0', 'menu', '[]', '2022-07-11 17:23:52', 'Admin', '2022-07-11 17:24:32', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1546425293617631233, '课程评论', 1546424575766695937, '[\"1546424575766695937\",\"1546425293617631233\"]', 'examcomment', 1, '/exam/comment', NULL, 'exam/comment', '', NULL, NULL, 66, b'0', b'1', b'0', 'menu', '[]', '2022-07-11 17:24:56', 'Admin', '2022-07-15 16:34:47', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1546425588003246081, '课程审核', 1546424575766695937, '[\"1546424575766695937\",\"1546425588003246081\"]', 'examcourseaudit', 1, '/exam/course/audit', NULL, 'exam/course/audit', '', NULL, NULL, 65, b'0', b'1', b'0', 'menu', '[]', '2022-07-11 17:26:06', 'Admin', '2022-07-11 17:26:31', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1560522611887312897, '工作流管理', 1505750499046068225, '[\"1505750499046068225\",\"1560522611887312897\"]', 'sysworkflow', 1, '/sys/workflow', NULL, 'sys/workflow', 'sc-icon-organization', NULL, NULL, 10, b'0', b'1', b'0', 'menu', '[]', '2022-08-19 15:02:38', 'Admin', '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1560525424562409472, '工作流设计', 1560522611887312897, '[\"1560522611887312897\",\"1560525424562409472\"]', 'sysworkflowdesign', 1, '/sys/workflow/design', NULL, 'sys/workflow/design', '', NULL, NULL, 68, b'1', b'0', b'0', 'menu', '[]', '2022-08-19 15:13:49', 'Admin', '2022-08-19 15:14:37', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1562004677845979136, '通知管理', 1505750499046068225, '[\"1505750499046068225\",\"1562004677845979136\"]', 'sysnotice', 1, '/sys/notice', NULL, 'sys/notice', 'el-icon-message', NULL, NULL, 8, b'0', b'1', b'0', 'menu', '[]', '2022-08-23 17:11:50', 'Admin', '2022-08-31 16:15:59', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1575680848341110784, '活动管理', 1506524557157208065, '[\"1506524557157208065\",\"1575680848341110784\"]', 'caractivity', 1, '/car/activity', NULL, NULL, 'el-icon-shopping-bag', NULL, NULL, 69, b'0', b'1', b'0', 'menu', '[]', '2022-09-30 10:56:04', 'Admin', '2022-09-30 10:56:53', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1575681070727303168, '活动列表', 1575680848341110784, '[\"1575680848341110784\",\"1575681070727303168\"]', 'caractivitylist', 1, '/car/activity/list', NULL, 'cars/activity', '', NULL, NULL, 70, b'0', b'1', b'0', 'menu', '[]', '2022-09-30 10:56:57', 'Admin', '2022-09-30 11:01:55', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1578994071928705024, '社区', 1590627984631533568, '[\"1578994071928705024\"]', 'community', 1, 'community', NULL, NULL, 'el-icon-partly-cloudy', NULL, NULL, 71, b'0', b'1', b'0', 'menu', '[]', '2022-10-09 14:21:38', 'Admin', '2022-10-09 14:23:45', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1578994281438384128, '内容管理', 1578994071928705024, '[\"1578994071928705024\",\"1578994281438384128\"]', 'community-list', 1, '/community/list', NULL, 'community/index', 'el-icon-document-copy', NULL, NULL, 72, b'0', b'1', b'0', 'menu', '[]', '2022-10-09 14:22:28', 'Admin', '2022-10-09 14:23:13', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1578994617523769344, '评论管理', 1578994071928705024, '[\"1578994071928705024\",\"1578994617523769344\"]', 'community-comment', 1, '/community/comment', NULL, 'community/comment', 'el-icon-chat-line-square', NULL, NULL, 73, b'0', b'1', b'0', 'menu', '[]', '2022-10-09 14:23:48', 'Admin', '2022-10-09 14:24:19', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1578994755457650688, '勋章管理', 1578994071928705024, '[\"1578994071928705024\",\"1578994755457650688\"]', 'community-medal', 1, '/community/medal', NULL, 'community/medal', 'el-icon-medal', NULL, NULL, 74, b'0', b'1', b'0', 'menu', '[]', '2022-10-09 14:24:21', 'Admin', '2022-10-09 14:25:17', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1580819302175608832, '访问白名单', 1506524557157208065, '[\"1506524557157208065\",\"1580819302175608832\"]', 'carswhitelist', 1, '/cars/white', NULL, 'cars/white', 'el-icon-document-copy', NULL, NULL, 75, b'0', b'1', b'0', 'menu', '[]', '2022-10-14 15:14:26', 'Admin', '2022-10-14 15:15:35', 'Admin', 0);
INSERT INTO `sys_menu` VALUES (1588347216035188736, '租户', 0, '[\"1588347216035188736\"]', 'tenant', 1, '/tenant', NULL, NULL, 'el-icon-basketball', NULL, NULL, 76, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 09:47:41', '李四', '2022-11-04 09:48:03', '李四', 0);
INSERT INTO `sys_menu` VALUES (1588347320808902656, '租户管理', 1588347216035188736, '[\"1588347216035188736\",\"1588347320808902656\"]', 'tenanthome', 1, '/tenant/home', NULL, 'tenant/index', 'el-icon-help', NULL, NULL, 77, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 09:48:06', '李四', '2022-11-04 09:48:56', '李四', 0);
INSERT INTO `sys_menu` VALUES (1588347545279664128, '租户资源', 1588347216035188736, '[\"1588347216035188736\",\"1588347545279664128\"]', 'tenantmenu', 1, '/tenant/menu', NULL, 'tenant/menu', 'el-icon-fold', NULL, NULL, 78, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 09:49:00', '李四', '2022-11-04 09:49:35', '李四', 0);
INSERT INTO `sys_menu` VALUES (1588347702473789440, '租户权限', 1588347216035188736, '[\"1588347216035188736\",\"1588347702473789440\"]', 'tenantauthority', 1, '/tenant/authority', NULL, 'tenant/authority', 'el-icon-finished', NULL, NULL, 79, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 09:49:37', '李四', '2022-11-04 09:50:05', '李四', 0);
INSERT INTO `sys_menu` VALUES (1588370141991800832, '主页', 0, '[\"1588370141991800832\"]', 'tenanthome', 1, '/tenanthome', NULL, NULL, 'el-icon-house', NULL, NULL, 80, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 11:18:47', NULL, '2022-11-04 11:19:23', '李四', 1);
INSERT INTO `sys_menu` VALUES (1588371331920039936, '工作台', 1588370141991800832, '[\"1588370141991800832\",\"1588371331920039936\"]', 'workbench', 1, '/tenant/home', NULL, 'tenant/home', 'el-icon-dish', NULL, NULL, 81, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 11:23:31', NULL, '2022-11-04 11:24:09', '李四', 1);
INSERT INTO `sys_menu` VALUES (1588371601483763712, '系统', 0, '[\"1588371601483763712\"]', 'tenantsys', 1, '/tenantsys', NULL, NULL, 'el-icon-dish', NULL, NULL, 82, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 11:24:35', NULL, '2022-11-04 11:25:06', '李四', 1);
INSERT INTO `sys_menu` VALUES (1588371742273966080, '机构管理', 1588371601483763712, '[\"1588371601483763712\",\"1588371742273966080\"]', 'tenantorganize', 1, '/tenant/organize', NULL, 'sys/organize', 'el-icon-wind-power', NULL, NULL, 83, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 11:25:09', NULL, '2022-11-04 11:26:00', '李四', 1);
INSERT INTO `sys_menu` VALUES (1588371966342074368, '角色管理', 1588371601483763712, '[\"1588371601483763712\",\"1588371966342074368\"]', 'tenantrole', 1, '/tenant/role', NULL, 'sys/role', 'el-icon-filter', NULL, NULL, 84, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 11:26:02', NULL, '2022-11-04 11:26:41', '李四', 1);
INSERT INTO `sys_menu` VALUES (1588372137452900352, '用户管理', 1588371601483763712, '[\"1588371601483763712\",\"1588372137452900352\"]', 'tenantadmin', 1, '/tenant/admin', NULL, 'sys/admin', 'el-icon-user', NULL, NULL, 85, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 11:26:43', NULL, '2022-11-04 11:27:10', '李四', 1);
INSERT INTO `sys_menu` VALUES (1588372262950670336, '岗位管理', 1588371601483763712, '[\"1588371601483763712\",\"1588372262950670336\"]', 'tenantpost', 1, '/tenant/post', NULL, 'sys/post', 'el-icon-add-location', NULL, NULL, 86, b'0', b'1', b'0', 'menu', '[]', '2022-11-04 11:27:13', NULL, '2022-11-04 11:27:50', '李四', 1);
INSERT INTO `sys_menu` VALUES (1590623130446073856, '设置', 0, '[\"1590623130446073856\"]', 'setting', 1, '/setting', NULL, NULL, 'el-icon-setting', NULL, NULL, 91, b'0', b'1', b'0', 'menu', '[]', '2022-11-10 16:31:21', NULL, '2022-11-10 16:31:45', '李四', 0);
INSERT INTO `sys_menu` VALUES (1590627984631533568, '应用', 0, '[\"1590627984631533568\"]', 'application', 1, '/application', NULL, NULL, 'el-icon-menu', NULL, NULL, 87, b'0', b'1', b'0', 'menu', '[]', '2022-11-10 16:50:39', NULL, '2022-11-10 16:52:10', '李四', 0);
INSERT INTO `sys_menu` VALUES (1603310233457922048, '系统监控', 1505743735667953665, '[\"1505743735667953665\",\"1603310233457922048\"]', 'monitoring', 1, '/monitoring', NULL, 'home/monitoring', 'el-icon-data-line', NULL, NULL, 103, b'0', b'1', b'0', 'menu', '[]', '2022-12-15 16:45:22', NULL, '2022-12-15 16:48:04', '李四', 0);
INSERT INTO `sys_menu` VALUES (1603575083291512832, '接口文档', 1505743735667953665, '[\"1505743735667953665\",\"1603575083291512832\"]', 'api-doc', 1, 'http://114.115.174.32:5100/fytapiui/index.html', NULL, NULL, 'el-icon-document', NULL, NULL, 104, b'0', b'1', b'0', 'link', '[]', '2022-12-16 10:17:47', NULL, '2022-12-16 14:07:54', '李四', 0);
INSERT INTO `sys_menu` VALUES (1622490755526430720, '角色互斥', 1505754140607909889, '[\"1505754140607909889\",\"1622490755526430720\"]', 'sys-roleconflict', 1, '/sys/roleconflict', NULL, 'sys/roleconflict', 'el-icon-cherry', NULL, NULL, 105, b'0', b'1', b'0', 'menu', '[]', '2023-02-06 15:01:55', NULL, '2023-02-06 15:02:28', '李四', 0);
INSERT INTO `sys_menu` VALUES (1622490907251183616, '权限设置', 1505754140607909889, '[\"1505754140607909889\",\"1622490907251183616\"]', 'sys-permission', 1, '/sys/permission', NULL, 'sys/permission', 'el-icon-setting', NULL, NULL, 106, b'0', b'1', b'0', 'menu', '[]', '2023-02-06 15:02:31', NULL, '2023-02-06 15:03:20', '李四', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_message
-- ----------------------------
DROP TABLE IF EXISTS `sys_message`;
CREATE TABLE `sys_message` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `ColumnId` bigint NOT NULL DEFAULT '0' COMMENT '栏目Id',
  `Types` int NOT NULL DEFAULT '1' COMMENT '类型',
  `Title` varchar(64) DEFAULT NULL COMMENT '留言标题',
  `Email` varchar(64) DEFAULT NULL COMMENT '邮箱信息',
  `Mobile` varchar(32) DEFAULT NULL COMMENT '手机号码',
  `Tags` varchar(128) DEFAULT NULL COMMENT '留言标签',
  `Summary` varchar(1024) DEFAULT NULL COMMENT '留言内容',
  `IsRead` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否已读',
  `IsDelete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `UserName` varchar(32) DEFAULT NULL COMMENT '用户姓名',
  `CreateTime` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '添加时间',
  `CreateUser` varchar(32) DEFAULT NULL COMMENT '添加人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(32) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='留言消息表';

-- ----------------------------
-- Records of sys_message
-- ----------------------------
BEGIN;
INSERT INTO `sys_message` VALUES (1388447984265596928, 0, 1, '这里面是标题', '7155@qq.com', '135110110110', '测试、游戏、工作、需求', '具体的留言信息，请查看', b'1', b'0', 1260380358965334016, '张三', '2022-08-24 16:04:32', 'string', '2021-05-01 10:58:34', 'string', 0);
INSERT INTO `sys_message` VALUES (1391649539160674304, 0, 2, '留言信息10010220011', 'string', 'string', 'string', 'string', b'1', b'1', 1260380358965334016, 'string', '2022-08-24 16:04:33', 'string', '2021-05-10 07:00:51', 'string', 0);
INSERT INTO `sys_message` VALUES (1391649554780262400, 0, 2, '留言信息10010220011', 'string', 'string', 'string', 'string', b'1', b'1', 1260380358965334016, 'string', '2022-08-24 16:04:35', 'string', '2021-05-10 07:00:51', 'string', 0);
INSERT INTO `sys_message` VALUES (1391649555568791552, 0, 2, '留言信息10010220011', 'string', 'string', 'string', 'string', b'1', b'0', 1260380358965334016, 'string', '2022-08-24 16:04:35', 'string', '2021-05-10 07:00:51', 'string', 0);
INSERT INTO `sys_message` VALUES (1391649557682720768, 0, 2, '留言信息10010220011', 'string', 'string', 'string', 'string', b'1', b'0', 1260380358965334016, 'string', '2022-08-24 16:04:36', 'string', '2021-05-10 07:00:51', 'string', 0);
INSERT INTO `sys_message` VALUES (1391649558261534720, 0, 2, '留言信息10010220011', 'string', 'string', 'string', 'string', b'1', b'1', 1260380358965334016, 'string', '2022-08-24 16:04:37', 'string', '2021-05-10 07:00:51', 'string', 0);
INSERT INTO `sys_message` VALUES (1509494310993793025, 0, 1, '问题反馈', 'ddd@qq.com', NULL, NULL, 'sddddddddddd', b'1', b'0', 1260380358965334016, NULL, '2022-08-24 16:04:38', NULL, NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1509494437967958017, 0, 1, '问题反馈', '2223@qq.com', NULL, NULL, '2222223333333', b'1', b'0', 1260380358965334016, NULL, '2022-08-24 16:04:39', NULL, NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1511967403649667073, 0, 1, '问题反馈', '121221@qq.com', '', NULL, '12121ssssss', b'1', b'0', 1260380358965334016, 'Jason.付裕', '2022-08-24 16:04:41', NULL, NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1591346051028226048, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1591358313348599808, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1591684604912340992, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1591715478072594432, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1519584258979663873, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1591715503053869056, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1591718988969283584, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1591719954011525120, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592066244146761728, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592076144356757504, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592076759052980224, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592077714075029504, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592087397418536960, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592087420902445056, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592087441349677056, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592087457778765824, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592087474967023616, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592091942722867200, 1591346050986283008, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1592090369141641216, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592355557535256576, 1592355557526867968, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1592090369141641216, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592357308984332288, 1592355557526867968, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1592090369141641216, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592418777637720064, 1592355557526867968, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1592090369141641216, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592683729241903104, 1592355557526867968, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1592090369141641216, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592782322556604417, 1592355557526867968, 3, '【流转】您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', 'admin_fy', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592800433724854272, 1592355557526867968, 3, '【流转】您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1592090369141641216, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592802610958700545, 1592355557526867968, 3, '【流转】您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', 'admin_fy', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1592803031777415169, 1592355557526867968, 3, '【流转】您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1592090369141641216, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1593176410204278784, 1592355557526867968, 3, '【流转】您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1260380358965334016, NULL, '1900-01-01 00:00:00', 'admin_fy', NULL, NULL, 0);
INSERT INTO `sys_message` VALUES (1593522046380412928, 1593522046367830016, 3, '您有一个新的工单等您处理，请及时查看~', NULL, NULL, NULL, NULL, b'0', b'0', 1592090369141641216, NULL, '1900-01-01 00:00:00', '李四', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
  `Id` bigint NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `SendUserId` bigint NOT NULL DEFAULT '0' COMMENT '发送人编号',
  `AcceptUserIds` varchar(2000) NOT NULL DEFAULT '0' COMMENT '接收人编号(0=全员)',
  `Title` varchar(255) NOT NULL COMMENT '通知标题',
  `Content` longtext COMMENT '通知内容',
  `Files` varchar(900) DEFAULT NULL COMMENT '附件内容支持多个',
  `Status` int NOT NULL DEFAULT '0' COMMENT '1=草稿2=存档3=删除',
  `IsSend` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否为发送邮件',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知模块';

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
BEGIN;
INSERT INTO `sys_notice` VALUES (1506528469780140123, 1519584258979663873, '[0]', '测试通知', '这里面是内容', '', 0, b'0', '2022-08-29 14:32:39', 'admin', '2022-10-28 14:31:23', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_notice_read
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice_read`;
CREATE TABLE `sys_notice_read` (
  `Id` bigint NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `NoticeId` bigint NOT NULL DEFAULT '0' COMMENT '通知编号',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `IsRead` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否已读',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知已读模块';

-- ----------------------------
-- Records of sys_notice_read
-- ----------------------------
BEGIN;
INSERT INTO `sys_notice_read` VALUES (1585885889932955649, 1506528469780140123, 1260380358965334016, b'1', '2022-10-28 14:47:15', 'Admin', 0);
INSERT INTO `sys_notice_read` VALUES (1602490921675526144, 1506528469780140123, 5, b'1', '2022-12-13 10:29:43', '李四', 0);
INSERT INTO `sys_notice_read` VALUES (1602490927014875136, 1506528469780140123, 7, b'1', '2022-12-13 10:29:44', '李四', 0);
INSERT INTO `sys_notice_read` VALUES (1602490995797266432, 1506528469780140123, 13, b'1', '2022-12-13 10:30:01', '李四', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_organize
-- ----------------------------
DROP TABLE IF EXISTS `sys_organize`;
CREATE TABLE `sys_organize` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `ParentId` bigint NOT NULL COMMENT '父节点',
  `Name` varchar(30) NOT NULL COMMENT '部门名称',
  `Number` varchar(30) DEFAULT NULL COMMENT '机构编码',
  `ParentIdList` varchar(500) DEFAULT NULL COMMENT '父节点集合',
  `Layer` int NOT NULL DEFAULT '0' COMMENT '部门层级',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '删除状态',
  `LeaderUser` varchar(20) DEFAULT NULL COMMENT '部门负责人',
  `LeaderMobile` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `LeaderEmail` varchar(50) DEFAULT NULL COMMENT '联系邮箱',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='组织机构表';

-- ----------------------------
-- Records of sys_organize
-- ----------------------------
BEGIN;
INSERT INTO `sys_organize` VALUES (1247889786656657408, 0, 'Fyt集团', 'aa', '[\"0\"]', 1, 1, b'1', b'0', '1', '111', '1111', '2020-04-08 22:11:24', 'admin', NULL, NULL, 0);
INSERT INTO `sys_organize` VALUES (1248157435479330816, 1247889786656657408, '行政/人事', 'bb', '[\"1247889786656657408\"]', 2, 2, b'1', b'0', '李四', '13688888888', '58555@qq.com', '2020-04-09 15:54:57', 'admin', '2022-08-25 20:55:37', 'Admin', 0);
INSERT INTO `sys_organize` VALUES (1588429899922804736, 0, '默认机构', '10000', '[]', 0, 4, b'1', b'0', NULL, NULL, NULL, '2022-11-04 15:16:14', '李四', NULL, NULL, 1588429898672902144);
COMMIT;

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `RoleId` bigint NOT NULL COMMENT '角色编号',
  `MenuId` bigint DEFAULT NULL COMMENT '菜单编号',
  `Api` varchar(2000) DEFAULT NULL COMMENT '按钮功能组',
  `Types` int NOT NULL DEFAULT '1' COMMENT '授权类型1=角色-菜单 2=用户-角色 3=角色-菜单-按钮功能',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='授权表';

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505743735667953665, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505749765281943553, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505750741799800833, '[{\"code\":\"查看\",\"method\":\"POST\",\"url\":\"/api/generator\"},{\"code\":\"生成\",\"method\":\"POST\",\"url\":\"/api/generator\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505751087574028289, '[{\"code\":\"上传\",\"method\":\"POST\",\"url\":\"/api/sysfile/upload\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysfile/file\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505752932937764865, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505753200123318273, '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysorganize\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysorganize\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysorganize\"},{\"code\":\"排序\",\"method\":\"POST\",\"url\":\"/api/sysorganize/colsort\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505753465199136769, '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysrole\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysrole\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysrole\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505753657151459329, '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/syspost\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/syspost\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/syspost\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505753850097831937, '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysadmin\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysadmin\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysadmin\"},{\"code\":\"密码重置\",\"method\":\"PUT\",\"url\":\"/api/sysadmin/passreset\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505753983766106113, '[{\"code\":\"添加\",\"method\":\"POST\",\"url\":\"/api/sysmenu/temp\"},{\"code\":\"编辑\",\"method\":\"PUT\",\"url\":\"/api/sysmenu\"},{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/sysmenu\"},{\"code\":\"排序\",\"method\":\"POST\",\"url\":\"/api/sysmenu/colsort\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505754140607909889, '[{\"code\":\"保存\",\"method\":\"POST\",\"url\":\"/api/sysauthority\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505754323739611137, '[{\"code\":\"删除\",\"method\":\"DELETE\",\"url\":\"/api/syslog\"},{\"code\":\"清空\",\"method\":\"DELETE\",\"url\":\"/api/syslog/clear\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1519508966684626944, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505750037081231361, '[{\"code\":\"查看\",\"method\":\"GET\",\"url\":\"/api/sysadmin/basic\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505750499046068225, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1474270785488162818, 1505751488931172353, '[{\"code\":\"已读\",\"method\":\"PUT\",\"url\":\"/api/sysmessage/read\"},{\"code\":\"回收站\",\"method\":\"DELETE\",\"url\":\"/api/sysmessage/recycle\"}]', 3, 0);
INSERT INTO `sys_permission` VALUES (1588429900010885120, 1588370141991800832, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1588429900010885120, 1588371331920039936, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1588429900010885120, 1588371601483763712, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1588429900010885120, 1588371742273966080, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1588429900010885120, 1588371966342074368, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1588429900010885120, 1588372137452900352, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1588429900010885120, 1588372262950670336, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505743735667953665, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505749765281943553, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505750037081231361, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1603310233457922048, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1603575083291512832, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1588347216035188736, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1588347320808902656, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1588347545279664128, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1588347702473789440, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1590627984631533568, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506093853084618753, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506094265032380417, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506094494225928193, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506094671250722817, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1527239267519172608, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506187567358414849, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506188179915542529, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506188430009307137, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506524557157208065, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506524879816626177, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506559646230515713, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506560054290157569, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506560247593046017, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506812417865289729, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506812669225734145, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1506812834963656705, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1514445260992942081, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1575680848341110784, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1575681070727303168, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1580819302175608832, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1539525292010377216, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1540250135517335553, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1539528489735163905, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1539529100392271873, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1539529362251059201, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1539528825413701633, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1544215708278329344, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1544224763176685568, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1545245498565332993, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1545245798642618369, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1545246104927473664, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1539526260865241089, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1546423325385953280, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1546423680886771713, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1546424056004349953, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1546424207448084481, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1546424575766695937, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1546425026297860097, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1546425588003246081, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1546425293617631233, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1578994071928705024, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1578994281438384128, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1578994617523769344, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1578994755457650688, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505750499046068225, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505750741799800833, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505751087574028289, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505764157008515073, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505751622146461697, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1530078871695790080, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1519880746058256384, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1562004677845979136, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505751488931172353, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1560522611887312897, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1560525424562409472, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505751857547579393, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505752082601349121, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505752395358015489, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505752728201203713, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505753200123318273, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505753465199136769, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505753657151459329, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505753850097831937, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505753983766106113, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1622490755526430720, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1622490907251183616, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505754323739611137, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1519508966684626944, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1590623130446073856, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505752932937764865, '[]', 3, 0);
INSERT INTO `sys_permission` VALUES (1339756014718816256, 1505754140607909889, '[]', 3, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `Name` varchar(30) NOT NULL COMMENT '岗位名称',
  `Number` varchar(6) DEFAULT NULL COMMENT '岗位编码',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '岗位状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '删除状态',
  `Summary` varchar(500) DEFAULT NULL COMMENT '备注信息',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='岗位表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` VALUES (1251019168074043392, '项目经理', '100001', 1, b'1', b'0', '项目经理', '2020-04-17 13:26:27', 'admin', NULL, NULL, 0);
INSERT INTO `sys_post` VALUES (1251019232876040192, '测试经理', '100002', 2, b'1', b'0', '测试经理', '2020-04-17 13:26:27', 'admin', '0001-01-01 00:00:00', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `Name` varchar(30) NOT NULL COMMENT '角色名称',
  `ParentId` bigint DEFAULT NULL COMMENT '角色父节点',
  `ParentIdList` varchar(500) DEFAULT NULL COMMENT '父节点结合',
  `Layer` int NOT NULL DEFAULT '1' COMMENT '角色层级',
  `Number` varchar(6) DEFAULT NULL COMMENT '角色编号',
  `IsSystem` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否超级管理员',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `Sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `MaxLength` int NOT NULL DEFAULT '0' COMMENT '角色最大数',
  `Summary` varchar(500) DEFAULT NULL COMMENT '描述',
  `Console` varchar(50) DEFAULT NULL COMMENT '控制台',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(20) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1339755942329323520, '管理员', 0, '[\"1339755942329323520\",\"1339755942329323520\",\"1339755942329323520\"]', 1, '123', b'0', b'1', 2, 0, '2222', 'work', b'0', '2020-12-18 10:14:42', NULL, '2022-04-25 17:19:49', 'Admin', 0);
INSERT INTO `sys_role` VALUES (1339756014718816256, '系统管理员', 1339755942329323520, '[\"1339755942329323520\",\"1339756014718816256\"]', 2, '456', b'1', b'1', 1, 0, NULL, 'work', b'0', '2020-12-18 10:15:00', NULL, '0001-01-01 00:00:00', '\0', 0);
INSERT INTO `sys_role` VALUES (1339770084108931072, '业务管理员', 1339755942329323520, '[\"1339755942329323520\",\"1339770084108931072\"]', 2, '789', b'0', b'1', 3, 0, NULL, 'work', b'0', '2020-12-18 11:10:54', NULL, '0001-01-01 00:00:00', '\0', 0);
INSERT INTO `sys_role` VALUES (1474270544022081536, '操作员', 0, '[1474270544022081536]', 1, '123', b'0', b'1', 4, 0, NULL, 'work', b'0', '2020-12-18 10:14:42', NULL, '0001-01-01 00:00:00', '\0', 0);
INSERT INTO `sys_role` VALUES (1474270613328760833, '审核员', 1474270544022081536, '[\"1474270544022081536\",\"1474270613328760833\"]', 2, '123', b'0', b'1', 5, 0, NULL, 'stats', b'0', '2020-12-18 10:14:42', NULL, '0001-01-01 00:00:00', '', 0);
INSERT INTO `sys_role` VALUES (1474270654994976769, '复审员', 1474270544022081536, '[\"1474270544022081536\",\"1474270654994976769\"]', 2, '123', b'0', b'1', 6, 0, NULL, 'work', b'0', '2020-12-18 10:14:42', NULL, '0001-01-01 00:00:00', '\0', 0);
INSERT INTO `sys_role` VALUES (1474270785488162818, '数据管理员', 1339755942329323520, '[\"1339755942329323520\",\"1474270785488162818\"]', 2, '789', b'0', b'1', 7, 0, NULL, 'work', b'0', '2020-12-18 11:10:54', NULL, '0001-01-01 00:00:00', '', 0);
INSERT INTO `sys_role` VALUES (1588429900010885120, '超级管理员', 0, NULL, 1, '10000', b'1', b'1', 8, 0, NULL, NULL, b'0', '2022-11-04 15:16:14', '李四', NULL, NULL, 1588429898672902144);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_conflict
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_conflict`;
CREATE TABLE `sys_role_conflict` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  `RoleA` bigint DEFAULT NULL COMMENT '角色A',
  `RoleB` bigint DEFAULT NULL COMMENT '角色B',
  `Summary` varchar(255) DEFAULT NULL COMMENT '互斥说明',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色互斥表';

-- ----------------------------
-- Records of sys_role_conflict
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_conflict` VALUES (1622491878991728640, 0, 1339770084108931072, 1474270785488162818, '业务-数据', '2023-02-06 15:06:23', '李四', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_scheduler
-- ----------------------------
DROP TABLE IF EXISTS `sys_scheduler`;
CREATE TABLE `sys_scheduler` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `JobName` varchar(255) NOT NULL COMMENT '任务名称',
  `JobGroup` varchar(255) NOT NULL COMMENT '任务组',
  `BeginTime` datetime NOT NULL COMMENT '开始时间',
  `EndTime` datetime DEFAULT NULL COMMENT '结束时间',
  `Cron` varchar(255) NOT NULL COMMENT 'Cron表达式',
  `TriggerType` int NOT NULL DEFAULT '1' COMMENT '触发器类型',
  `RequestUrl` varchar(255) DEFAULT NULL COMMENT '请求url',
  `RequestParameters` varchar(900) DEFAULT NULL COMMENT '请求参数（Post，Put请求用）',
  `Headers` varchar(900) DEFAULT NULL COMMENT 'Headers',
  `RequestType` int NOT NULL DEFAULT '2' COMMENT '请求类型',
  `Description` varchar(255) DEFAULT NULL COMMENT '描述',
  `TriggerState` int DEFAULT '0' COMMENT '任务状态',
  `LastErrMsg` varchar(900) DEFAULT NULL COMMENT '上次执行异常信息',
  `PreviousFireTime` datetime DEFAULT NULL COMMENT '上次执行时间',
  `NextFireTime` datetime DEFAULT NULL COMMENT '下次执行时间',
  `CreateTime` datetime NOT NULL,
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='任务调度';

-- ----------------------------
-- Records of sys_scheduler
-- ----------------------------
BEGIN;
INSERT INTO `sys_scheduler` VALUES (1458633937034285057, 'Dd_Task_1', '调度组', '2021-11-11 11:13:20', '2021-11-26 00:00:00', '0 0/10 * * * ? ', 1, 'http://localhost:5000/quartz/test', NULL, NULL, 1, NULL, 0, NULL, NULL, NULL, '2021-11-11 11:13:25', 0);
INSERT INTO `sys_scheduler` VALUES (1460438296701308928, 'Task1', '任务组', '2021-11-10 17:09:35', '2021-11-26 00:00:00', '0 0/10 * * * ? ', 1, 'http://localhost:5000/quartz/test', NULL, NULL, 1, NULL, 0, NULL, NULL, NULL, '2021-11-10 17:10:15', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant` (
  `Id` bigint NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  `Name` varchar(255) NOT NULL COMMENT '租户名称',
  `Person` varchar(255) NOT NULL COMMENT '负责人',
  `Phone` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `Account` varchar(255) NOT NULL COMMENT '默认账号',
  `PassWord` varchar(255) NOT NULL COMMENT '密码',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `IsDel` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='租户管理';

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant` VALUES (1574747178033876992, 0, '系统租户', '付先生', '13888888888', 'admin', '123456a!', b'1', b'0', '2022-09-27 21:05:59', 'Admin', '2022-09-27 21:07:10', 'Admin');
INSERT INTO `sys_tenant` VALUES (1588429899151052800, 1588429898672902144, 'fyadmin', 'fyadmin', NULL, 'fyadmin', '123456', b'1', b'0', '2022-11-04 15:16:14', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_vote
-- ----------------------------
DROP TABLE IF EXISTS `sys_vote`;
CREATE TABLE `sys_vote` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `Title` varchar(90) NOT NULL DEFAULT '0' COMMENT '投票标题',
  `Type` int NOT NULL DEFAULT '1' COMMENT '投票类型（图文、视频、分组）',
  `StartTime` datetime NOT NULL COMMENT '开始时间',
  `EndTime` datetime NOT NULL COMMENT '结束时间',
  `TickRule` int NOT NULL DEFAULT '1' COMMENT '勾选规则（单选、多选）',
  `SwipeRule` bit(1) NOT NULL DEFAULT b'1' COMMENT '防刷规则（IP限制）',
  `FileUrl` varchar(128) DEFAULT NULL COMMENT '文件地址',
  `Summary` varchar(900) DEFAULT NULL COMMENT '规则',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='投票表';

-- ----------------------------
-- Records of sys_vote
-- ----------------------------
BEGIN;
INSERT INTO `sys_vote` VALUES (1524656155928956928, '疫情的防控措施该如何进行？', 1, '2022-05-04 00:00:00', '2022-05-27 00:00:00', 2, b'1', '', '', '2022-05-12 15:42:09', 'Admin', '2022-05-12 17:25:53', 'Admin', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_vote_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_vote_item`;
CREATE TABLE `sys_vote_item` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `VoteId` bigint NOT NULL DEFAULT '0' COMMENT '投票编号',
  `Title` varchar(128) NOT NULL COMMENT '投票项标题',
  `Count` int NOT NULL DEFAULT '0' COMMENT '投票数量',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='投票项';

-- ----------------------------
-- Records of sys_vote_item
-- ----------------------------
BEGIN;
INSERT INTO `sys_vote_item` VALUES (1524656155954122752, 1524656155928956928, '居家办公，不聚集', 15, '2022-05-12 15:42:09', 'Admin', 0);
INSERT INTO `sys_vote_item` VALUES (1524656155954122753, 1524656155928956928, '根据疫情情况，阶段性管控', 30, '2022-05-12 15:42:09', 'Admin', 0);
INSERT INTO `sys_vote_item` VALUES (1524656155954122754, 1524656155928956928, '不用管，该干什么还干什么', 82, '2022-05-12 15:42:09', 'Admin', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_vote_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_vote_log`;
CREATE TABLE `sys_vote_log` (
  `Id` bigint NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `VoteId` bigint NOT NULL DEFAULT '0' COMMENT '投票编号',
  `VoteItemId` bigint NOT NULL DEFAULT '0' COMMENT '投票项编号',
  `UserId` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='投票日志';

-- ----------------------------
-- Table structure for sys_workflow
-- ----------------------------
DROP TABLE IF EXISTS `sys_workflow`;
CREATE TABLE `sys_workflow` (
  `Id` bigint NOT NULL COMMENT '唯一编号',
  `TypeId` bigint NOT NULL DEFAULT '0' COMMENT '流程类型',
  `Title` varchar(255) NOT NULL COMMENT '流程名称',
  `Icon` varchar(50) NOT NULL COMMENT '图标',
  `Refused` int NOT NULL DEFAULT '1' COMMENT '审批被拒后状态',
  `Status` bit(1) NOT NULL DEFAULT b'1' COMMENT '状态',
  `Summary` varchar(900) DEFAULT NULL COMMENT '流程说明',
  `Flow` longtext NOT NULL COMMENT '具体流程Json',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CreateUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUser` varchar(255) DEFAULT NULL COMMENT '修改人',
  `TenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='工作流';

-- ----------------------------
-- Records of sys_workflow
-- ----------------------------
BEGIN;
INSERT INTO `sys_workflow` VALUES (1560552757163855872, 0, 'aaaaa111111', 'aaaaa', 1, b'1', 'aaaaa', '{\"id\":1,\"name\":\"请假审批\",\"nodeConfig\":{\"nodeName\":\"发起人\",\"type\":0,\"nodeRoleList\":[],\"childNode\":{\"nodeName\":\"条件路由\",\"type\":4,\"conditionNodes\":[{\"nodeName\":\"长期\",\"type\":3,\"priorityLevel\":1,\"conditionMode\":1,\"conditionList\":[{\"label\":\"请假天数\",\"field\":\"day\",\"operator\":\">\",\"value\":\"7\"}],\"childNode\":{\"nodeName\":\"领导审批\",\"type\":1,\"setType\":1,\"nodeUserList\":[{\"id\":\"360000197302144442\",\"name\":\"何敏\"}],\"nodeRoleList\":[],\"examineLevel\":1,\"directorLevel\":1,\"selectMode\":1,\"termAuto\":false,\"term\":0,\"termMode\":1,\"examineMode\":1,\"directorMode\":0}},{\"nodeName\":\"短期\",\"type\":3,\"priorityLevel\":2,\"conditionMode\":1,\"conditionList\":[],\"childNode\":{\"nodeName\":\"直接主管审批\",\"type\":1,\"setType\":2,\"nodeUserList\":[],\"nodeRoleList\":[],\"examineLevel\":1,\"directorLevel\":1,\"selectMode\":1,\"termAuto\":false,\"term\":0,\"termMode\":1,\"examineMode\":1,\"directorMode\":0}}],\"childNode\":{\"nodeName\":\"抄送人\",\"type\":2,\"userSelectFlag\":true,\"nodeUserList\":[{\"id\":\"220000200908305857\",\"name\":\"何秀英\"}]}}}}', '2022-08-19 17:02:26', 'Admin', '2022-08-19 17:35:06', 'Admin', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
